Hi,

Take a look at the demo EMPLOYEE database - there's a couple of
SELECTable procedures, ALL_LANGS being one of them.

Basically, it's all about the keyword SUSPEND.

Also download the Language Reference and have a look at the
Storedprocedure And Trigger Language chapter.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com



would it be possible for the results of a stored procedure be queried
thru a select statement? if so, how?

thanks!
Maan 8)