meta data for this page
  •  

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