Subject Re: [firebird-support] call stroed procedure using select clause
Author Helen Borrie
At 04:53 PM 9/11/2004 +0200, you wrote:

>(FB 1.5, Delphi7 )
>how must be declared output parameters calling stored procedure with
>select clause ?
>the procedure has one input and 7 output parameters.
>select * from _stored_procedure ( parameters )

select * from stored_proc (:param1, :param2, :param3....)

Make sure the input parameters are in the correct order (same as the
declaration order in the SP). You can use any names you like for the input
parameters. Often in Delphi apps you will want to use parameter names that
match those of corresponding fields in a linked dataset.

You need to refer to the output parameters by their names as declared in
the SP's RETURNS clause.

Also make sure it is the type of SP that can return a dataset (uses