TIBCStoredProc 'parameter mismatch for procedure'

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Fabrice
Posts: 42
Joined: Tue 07 Sep 2010 09:44

TIBCStoredProc 'parameter mismatch for procedure'

Post by Fabrice » Thu 28 Sep 2017 14:55

Hello,

In version 5.x I use prepareSQL for TIBCStoredProc to get the parameters list of a 'Stored procedure'.
But since version 6.X (tested on 6.1.3 / Delphi 10.2 + Firebird 3.0.2) this give me an error :

Sample :

Code: Select all

    
with   ProceduresStockee do
     begin
       StoredProcName:='count_inventory';

       PrepareSql;
     
          Params[0].DataType:=ftstring;
          Params[0].ParamType:=ptInput;
          Params[0].AsString:='Avalue';
          Params[1].DataType:=ftinteger;
          Params[1].ParamType:=ptOUtput;
         ExecProc;
     result:=Params[2].asinteger;      
end;

Code: Select all

object ProceduresStockee: TIBCStoredProc
  Connection = MyDatabase
  AutoCalcFields = False
  Left = 235
  Top = 88
end
PrepareSql => Give me an error 'Dynamic SQL error input parameter mismatch for procedure "count_inventory"

Why it doesn't work and how to fix this problem ?
Last edited by Fabrice on Thu 28 Sep 2017 15:41, edited 2 times in total.

ViktorV
Devart Team
Posts: 2795
Joined: Wed 30 Jul 2014 07:16

Re: TIBCStoredProc 'parameter mismatch for procedure'

Post by ViktorV » Thu 28 Sep 2017 15:16

We have already fixed the issue with occurrence of the 'parameter mismatch for procedure' error . This fix will be included in the next build of IBDAC, which we are planning to release within within 1-2 days.

ViktorV
Devart Team
Posts: 2795
Joined: Wed 30 Jul 2014 07:16

Re: TIBCStoredProc 'parameter mismatch for procedure'

Post by ViktorV » Fri 29 Sep 2017 13:55

The new IBDAC 6.1.4 with a fix for this issue is already available for download now.

Post Reply