Linq2Db not all stored procedures scaffolding

[Nevega]

I've tried to scaffold an existing database using cli

dotnet linq2db scaffold -p Firebird -c "Server=;Database=;User Id=;Password=" --objects table,stored-procedure,aggregate-function --overwrite true
In result some stored procedures scaffold, but some do not. As I understand no scaffolding procedures which have out parameters.

[MaceWindu]

Could you provide sample definition of ignored procedure?

[Nevega]

For example ignored procedure code below

CREATE OR ALTER PROCEDURE GOOD$KITEXPQUANTS (GDKIT_ID INTEGER, ASTOCK_ID INTEGER, ASTOCKTYPE_ID INTEGER, FREPLACECARD SMALLINT, MAXLEVEL INTEGER, FDOTOTALIZE SMALLINT)
RETURNS (
	STOCK_ID INTEGER,
	QRCP DOUBLE PRECISION,
	QNT DOUBLE PRECISION,
	QRES DOUBLE PRECISION
)
AS
DECLARE VARIABLE  S_TYPE_ID     INTEGER;
DECLARE VARIABLE  FLAGS         INTEGER;
DECLARE VARIABLE  fTotal        SMALLINT;
DECLARE VARIABLE  TOT_QRCP      DOUBLE PRECISION;
DECLARE VARIABLE  TOT_QNT       DOUBLE PRECISION;
DECLARE VARIABLE  TOT_QRES      DOUBLE PRECISION;
BEGIN
  SELECT
    FLAGS
  FROM
    GOODS
  WHERE
    ID = :GDKIT_ID
  INTO
    :FLAGS;
  IF (BIT_AND(ZI(FLAGS), 2) = 0) THEN EXIT;
  IF (ZI(ASTOCK_ID) >= 0)
  THEN  ASTOCKTYPE_ID = -1;
  ELSE BEGIN
    ASTOCK_ID = -1;
    IF (AStockType_ID IS NULL)
    THEN AStockType_ID = -1;
	END
  IF (AStock_ID = 0) THEN AStockType_ID = 0;
  TOT_QRCP = 0;
  TOT_QNT  = 0;
  TOT_QRES = 0;
  MaxLevel = ZI(MaxLevel);  
  IF (ZI(fDOTOTALIZE) > 0)
  THEN fTotal = 1;
  ELSE fTotal = 0;
  IF (ZI(AStock_ID) >= 0) THEN  
  BEGIN
    SELECT
      ZF(QRCP),
      ZF(QNT),
      ZF(QRES)
    FROM
      GOOD$KITEXPQUANT(:GDKIT_ID, :ASTOCK_ID, NULL, :fReplacecard, 0, :MaxLevel)
    INTO
      :QRCP,
      :QNT,
      :QRES;
    STOCK_ID = ASTOCK_ID;
    SUSPEND;
  END
  ELSE
  IF (AStockType_ID >= 0) THEN  /* по группе складов */
  BEGIN
    FOR
      SELECT
        ID
      FROM
        STOCKS
      WHERE
        TYPE_ID = :AStockType_ID
    INTO
      :STOCK_ID
    DO
    BEGIN
      SELECT
        ZF(QRCP),
        ZF(QNT),
        ZF(QRES)
      FROM
        GOOD$KITEXPQUANT(:GDKIT_ID, :STOCK_ID, :AStockType_ID, :fReplacecard, 0, :MaxLevel)
      INTO
        :QRCP,
        :QNT,
        :QRES;
      IF (fTotal = 1) THEN
      BEGIN
        IF ((AStockType_ID > 0) OR ((STOCK_ID = 0) AND (AStockType_ID = 0))) THEN
        BEGIN
          TOT_QRCP = TOT_QRCP + QRCP;
          TOT_QNT = TOT_QNT + QNT;
          TOT_QRES = TOT_QRES + QRES;
        END
      END
      ELSE
        SUSPEND;
    END
    IF (fTotal = 1) THEN
    BEGIN
      STOCK_ID = -1;
      QRCP = TOT_QRCP;
      QNT  = TOT_QNT;
      QRES = TOT_QRES;
      SUSPEND;
    END
  END
  ELSE
  BEGIN
    FOR
      SELECT
        ID,
        TYPE_ID
      FROM
        STOCKS
      INTO
        :STOCK_ID,
        :S_TYPE_ID
    DO
    BEGIN
      SELECT
        ZF(QRCP),
        ZF(QNT),
        ZF(QRES)
      FROM
        GOOD$KITEXPQUANT(:GDKIT_ID, :STOCK_ID, :S_TYPE_ID, :fReplacecard, 0, :MaxLevel)
      INTO
        :QRCP,
        :QNT,
        :QRES;
      IF (fTotal = 1) THEN
      BEGIN
        IF (S_Type_ID > 0) THEN
        BEGIN
          TOT_QRCP = TOT_QRCP + QRCP;
          TOT_QNT  = TOT_QNT  + QNT;
          TOT_QRES = TOT_QRES + QRES;
        END
      END
      ELSE
        SUSPEND;
    END
    IF (fTotal = 1) THEN
    BEGIN
      STOCK_ID = -1;
      QRCP = TOT_QRCP;
      QNT  = TOT_QNT;
      QRES = TOT_QRES;
      SUSPEND;
    END    
  END
END

[MaceWindu]

Could you provide database creation script with required objects to reproduce it? I've tried to trim your procedure by removing references to missing objects and it works:

CREATE OR ALTER PROCEDURE GOOD$KITEXPQUANTS (GDKIT_ID INTEGER, ASTOCK_ID INTEGER, ASTOCKTYPE_ID INTEGER, FREPLACECARD SMALLINT, MAXLEVEL INTEGER, FDOTOTALIZE SMALLINT)
RETURNS (
	STOCK_ID INTEGER,
	QRCP DOUBLE PRECISION,
	QNT DOUBLE PRECISION,
	QRES DOUBLE PRECISION
)
AS
DECLARE VARIABLE  FLAGS         INTEGER;
DECLARE VARIABLE  fTotal        SMALLINT;
DECLARE VARIABLE  TOT_QRCP      DOUBLE PRECISION;
DECLARE VARIABLE  TOT_QNT       DOUBLE PRECISION;
DECLARE VARIABLE  TOT_QRES      DOUBLE PRECISION;
BEGIN
  SELECT
    FLAGS
  FROM
    GOODS
  INTO
    :FLAGS;
  IF (ASTOCK_ID >= 0)
  THEN  ASTOCKTYPE_ID = -1;
  ELSE BEGIN
    ASTOCK_ID = -1;
	END
  IF (AStock_ID = 0) THEN AStockType_ID = 0;
  TOT_QRCP = 0;
  TOT_QNT  = 0;
  TOT_QRES = 0;
  IF (fDOTOTALIZE > 0)
  THEN fTotal = 1;
  ELSE fTotal = 0;
    SELECT
      QRCP,
      QNT,
      QRES
    FROM
      GOODS2
    INTO
      :QRCP,
      :QNT,
      :QRES;
    STOCK_ID = ASTOCK_ID;
    SUSPEND;
END

[Nevega]

here, under link the db backup maybe it will be more helpful?
https://github.com/Nevega/test_bd_Firebird/tree/master/test_bd

[MaceWindu]

Let's continue here #4447