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:

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) = '')
  ...