It is probably better to ask to the ibpp list:

ibpp-discuss@...

Fulvio Senore

sperlis ha scritto:

> Hello all,
> I am trying to (learn) to use Stored Procedures in Firebird using
> IBPP. I have added the stored procedure:
>
> CREATE PROCEDURE TestProc
> RETURNS (five_val INTEGER)
> AS BEGIN
> five_val = 5;
> END;
>
> When I execute it, there is no error (i.e. no exception) which I
> assume means "all's well". My question is: where do I see "five_val"?
> I assumed it would appear as a row with a single column, but it isn't
> :-(. Looking at the implementation (statement.cpp) it says "Should
> return at most a single row". Does that mean I can not retrieve more
> than a single row of data?
>
> Until now we've done everything using SELECT queries, so I am quite
> unfamiliar with stored procedures (in Firebird and in general). Am I
> missing something in the procedure itself?
>
> Thanks