Dan,

Use a "selectable" stored procedure and invoke it with a select
statement.... like this:

set term ^;
create procedure foo returns (name varchar(32), id (integer))
as begin
for select rdb$relation_name, rdb$relation_id
from rdb$relations
into :name, :id
do begin
suspend;
end
end^

set term ;^

select * from foo;

Regards,


Ann