Firebird Create Procedure
The Firebird Create Procedure Tool allows users to create stored procedures for a database. The following example is output for Firebird.
CREATE PROCEDURE test_procedure (param1 CHAR(25), param2 DATE, param3 DECIMAL)
-- RETURNS (param datatype, param datatype, . . .)
AS BEGIN
-- insert body here
END