Hi
You need a selectable stored procedure

SQLEXEC(nConnHnd, [SELECT * FROM MY_SP( ?param )])

stored procedure sample

CREATE PROCEDURE MY_SP (
    PARAM INTEGER)
RETURNS (
    COL1 INTEGER,
    COL2 INTEGER)
AS
begin
    for select col1, col2 from parent_table where id_parent = :param
    into :col1, :col2 do
    begin
      suspend;
    end
end

>Hi,
>
>How can I return multiple rows from a Stored Procedure in Firebird database?
>
>Thank you
>
>Adionei