Hi Steve,

RETURNING_VALUES is a psql language element. Use it inside a stored
procedure when retrieving returnvalues from another procedure executed
there.

Using a TIB_DSQL component you do something like this:

.
.
dsql.SQL := 'EXECUTE PROCEDURE spClearIxTables(:INPUTPAR1,.... )';
dsql.Prepare;
dsql.ParamByName('INPUTPAR1').AsSomeType := AValue;
.
.
dsql.ExecSQL;
MyResult := dsql.FIELDByName('PSUCCESS').AsSomeType;
.
.

--- In IBObjects@yahoogroups.com, "Steve Harp" <steve@h...> 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
>
>
> [Non-text portions of this message have been removed]