Hello Yosvany,

> Can any Stored Procedure return more than one row?

Yes. This type of SP is called a "selectable stored procedure". In
the SP, you populate the fields inside a loop and then call SUSPEND
(this is usually the last statement in the loop) to give the caller
the opportunity to fetch the row.

This kind of SP is not called with EXECUTE PROCEDURE; instead, you
SELECT from it, just as if it was a table or view.

If you're a Firebird beginner, get the Quickstart Guide:

http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_quickstart

Also get this InterBase documentation set:

http://www.ibphoenix.com/downloads/60All.zip

You'll find everything you need to know about SPs in there.

If you use Firebird 1.5, also look at the Release Notes.


Greetings,
Paul Vinkenoog