CREATE PROCEDURE

<< CREATE INDEX | FB 2.0 Language Reference | CREATE SEQUENCE >>

CREATE PROCEDURE

Available in: DSQL, ESQL

Changed in: 2.0

Description

It is now possible to provide default values for stored procedure arguments, allowing the caller to omit one or more items from the end of the argument list.

Syntax

 PROCEDURE procname (<inparam> [, <inparam> ...])
    ...

 <inparam> ::= paramname datatype [{= | DEFAULT} value]

Important: If you give a parameter a default value, all parameters coming after it must also get default values.

Example

 create procedure TestProc
    (a int, b int default 8, s varchar(12) = '')
    ...

See also:
CREATE OR ALTER EXCEPTION
ALTER PROCEDURE
CREATE EXCEPTION
DROP EXCEPTION
Stored Procedure
DROP PROCEDURE
EXECUTE PROCEDURE
SELECT
DDL - Data Definition Language

back to top of page
<< CREATE INDEX | FB 2.0 Language Reference | CREATE SEQUENCE >>