Convert your MS-Sql to Firebird, here is a simple example
Here the MS-Sql stored procedure
CREATE PROCEDURE town_S
AS
BEGIN
SET NOCOUNT OFF;
SELECT
TownID
, Description
FROM tblTows
END
And here the Firebird Stored procedure
SET TERM ^ ;
CREATE PROCEDURE town_S
RETURNS (
OUT_TOWN_ID Integer,
OUT_DESC Varchar(100) )
AS
BEGIN
FOR SELECT t.TOWNID, t.DESCRIPTION
FROM TBLTOWNS AS t
into
:OUT_TOWN_ID
, :OUT_DESC
DO
BEGIN
suspend;
END
END^
SET TERM ; ^