CREATE PROCEDURE syntax

Go Up to Creating Procedures

CREATE PROCEDURE name
[(param datatype [, param datatype …])]
 [RETURNS (param datatype [, param datatype …])]
 AS
 <procedure_body>;
<procedure_body> = [<variable_declaration_list>]

 <block>
<variable_declaration_list> =
 DECLARE VARIABLE var datatype;
[DECLARE VARIABLE var datatype; …]
<block> =
 BEGIN
 <compound_statement>
 [<compound_statement> …]
 END
<compound_statement> = {<block> | statement;}

Arguments of the CREATE PROCEDURE statement

Argument	Description
<name>	Name of the procedure; must be unique among procedure, table, and view names in the database.
<param> <datatype>	Input parameters that the calling program uses to pass values to the procedure. <param>: Name of the input parameter, unique for variables in the procedure. <datatype>: An InterBase data type
RETURNS <param datatype>	Output parameters that the procedure uses to return values to the calling program <param>: Name of the output parameter, unique for variables within the procedure. <datatype>: An InterBase data type The procedure returns the values of output parameters when it reaches a SUSPEND statement in the procedure body.
AS	Keyword that separates the procedure header and the procedure body.
DECLARE VARIABLE <var> <datatype>	Declares local variables used only in the procedure Each declaration must be preceded by DECLARE VARIABLE and followed by a semicolon (;). <var>: Name of the local variable, unique for variables in the procedure.
<statement>	Any single statement in InterBase procedure and trigger language. Each statement except BEGIN and END must be followed by a semicolon (;).