Subject Re: [firebird-support] SP more than one row
Author Paul Vinkenoog
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:

Also get this InterBase documentation set:

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

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

Paul Vinkenoog