set term ^;
create procedure test_groups
returns (a_group_name Varchar(252))
as

begin
  /* Loop on group_name */
  For
    SELECT group_name FROM groups
    into :a_group_name
 Do begin
   /*return data to client */
   Suspend ;
  end
end ^
set term; ^



To test your procedure, you can do :

select a_group_name from test_groups;



________________________________
De : firebirdsql <firebirdsql@...>
À : firebird-support@yahoogroups.com
Envoyé le : Samedi 17 Septembre 2011 5h44
Objet : [firebird-support] How to return recordset from stored procedure?


 
I got the following procedure:

CREATE PROCEDURE test_groups
AS
BEGIN
SELECT group_name FROM groups;
END^




[Non-text portions of this message have been removed]