Subject Re: [IBO] 4.9.14b32 - Problem with executable SP and output parameters
Author Thomas Steinmaurer
Hello Jason,

> migrating a legacy app from D2006 to D2010 for Unicode support.
> Currently I'm using 4.9.14b32.
>
> I have an executable SP (no SUSPEND in the SP) with a few input
> parameters and one output parameter:
>
> SET TERM ^^ ;
> CREATE PROCEDURE P_1 (
> ...
> )
> returns (
> VAR_ID Numeric(18,0))
> AS
> BEGIN
> VAR_ID = GEN_ID(MYGEN, 1);
> ...
> END ^^
> SET TERM ; ^^
>
>
> In the application I'm using a TIB_StoredProc and:
>
> ...
> myProc.ExecProc;
> ...
> myVar := FieldByName('VAR_ID').AsInt64;
>
>
> While this has worked in previous IBO versions, even in earlier 4.9.14
> versions, with b32, myVar is always 0.
>
> Any ideas?

Did you have time to investigate?


Thanks,
Thomas