Subject 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?

Thanks!

--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/