Firebird Select stored procedure

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 ; ^

Leave a Reply