Thomas,

I'll look at this right away. This is obviously a bug that has crept in.

Jason

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Thomas Steinmaurer
Sent: 10 January 2012 02:22 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] 4.9.14b32 - Problem with executable SP and output
parameters

Hello Jason,

>> Would you provide the SQL trace that the IBO trace monitor outputs so I

can

>> decipher exactly what API calls are being used?
>
> When using the TIB_StoredProc component.
>
> /*---
> EXECUTE2 DSQL
> TR_HANDLE = 6
> STMT_HANDLE = 3
> PARAMS = [ ]
> FIELDS = [ Version 1 SQLd 1 SQLn 1
> P1.RINT = 1 ]
>
> SECONDS = 0,016
> ----*/
> /*---
> COMMIT RETAINING
> TR_HANDLE = 6
> ----*/
>
>
> According to the trace, P1.RINT = 1, so the correct output parameter
> value should be available, but I do get 0 when accessing the field with:
>
> IB_StoredProc1.FieldByName('RINT').AsInteger
>
>
> After the ExecProc call.
>
>
> The SP is very simple:
>
> SET TERM ^^ ;
> CREATE PROCEDURE P1 returns (
> RINT Integer)
> AS
> begin
> RINT = 1;
> end ^^
> SET TERM ; ^^

I'm sorry for pushing you on this matter, but I want to avoid moving
away from TIB_StoredProc in favour of TIB_DSQL for executable procedures
in this legacy app, if there is possibly a fix in IBO for this or revert
back to some old behaviour as this has worked in older 4.9.14 builds.

Thanks!

Regards,
Thomas