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,