Subject Re: [ib-support] returning parameters
Author Helen Borrie
At 04:08 PM 7/03/2003 -0300, you wrote:
>hi everybody,
>hi helen,
>I need to return simple (not a table) parameters from a stored procedure.
>how can i do that ?

Simply define output arguments in the CREATE PROCEDURE header, using a
RETURNS (..) clause. See the Language Reference for correct syntax. In
your procedure, treat these arguments as variables, assigning the output
values to them.

How you read the output parameters on the client side depends on the client
interface layer you are using for development. For example, in native
Delphi and BCCPB, you can read the output parameters from the Params[]
array; in IBO, you read it from the Fields[] array. Other driver
interfaces will have other ways to surface the returned values...if you are
using the raw API, there is a parameter block structure that your code can
analyse following execution of the SP.