Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateDDL statements → CREATE PROCEDURE
Firebird Home Firebird Home Prev: CREATE INDEXFirebird Documentation IndexUp: DDL statementsNext: CREATE SEQUENCE

CREATE PROCEDURE

Tip

Find a more recent version at Firebird 5.0 Language Reference: 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: 

CREATE 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) = '')
  ...
Prev: CREATE INDEXFirebird Documentation IndexUp: DDL statementsNext: CREATE SEQUENCE
Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateDDL statements → CREATE PROCEDURE