Subject RE: [IBDI] Stored Procedure-Dataset
Author Claudio Valderrama C.
> -----Original Message-----
> From: Robert F. Tulloch [mailto:tultalk@...]
> Sent: Lunes 23 de Octubre de 2000 16:19
> Hi:
> In stored proc returning dataset do you have to declare all the
> fields returned in Returning or does it just return the dataset?

This seems more a question for the Mers list, by anyway: you need to declare
all fields in the Returning clause, so you need to use the INTO clause to
load the values of the SELECT in the output parameters. This is contrary to
MsSql, where you don't declare output parameters and can put directly a
SELECT statement that's returned by black magic. Notice that some 5.X
versions allowed to bypass the declaration of such output parameters... IMHO
this was a bug in IB. Of course, for selectable stored procedures, you need
the SUSPEND clause after loading values in the output parameters.