Subject Re: [IBO] Return values from stored procedure
Author James
Hi Steve
Steve Harp wrote:

> Hi All,
>
> I'm trying to get a return value from a stored procedure using a TIB_DSql
> component. I tried
> execute procedure spClearIxTables returning_values :pSuccess;
>
> but it barfed on the returning_values thing. Obviously, there's another
> way.
>
> Thanks for any help,
>
> Steve

My way of doing this task is using a TIB_Query with this sql instead
"select sSuccess from spClearIxTables"

Hope it works for you. Can we have a look on your SP?


james