Subject Re: [firebird-support] Re: "Invalid Request Handle" with stored procedures
Author Helen Borrie
At 04:02 AM 13/09/2003 +0000, you wrote:

>Ah, I see. I'm used to SQL Server where "EXECUTE PROCEDURE..." is good
>enough to return a daatset. So all I have to do is something like: "SELECT

Nothing so ugly!

Think of your SP's output set as if it were a table. The only difference
is that, if your proc has input arguments, you need to include them.

SELECT * FROM Myproc(Arg1, Arg2, ....);

More typically, from object interfaces:

SELECT * FROM Myproc(:param1, :param2,...);
or however your object passes parameters.