ALTER PROCEDURE

<< ALTER EXTERNAL FUNCTION | FB 2.0 Language Reference | ALTER SEQUENCE >>

ALTER PROCEDURE

Available in: DSQL, ESQL

Default argument values

Added in: 2.0

Description

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

Syntax

 ALTER 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

 alter procedure TestProc
    (a int, b int default 1007, s varchar(12) = '-')
    ...

Restriction on altering used procedures

Changed in: 2.0, 2.0.1

Description

In Firebird 2.0 only, a restriction is in place which prevents anyone from dropping, altering or recreating a trigger or stored procedure if it has been used since the database was opened. This restriction has been removed again in version 2.0.1. Still, performing these operations on a live database is potentially risky and should only be done with the utmost care.

See also:
CREATE PROCEDURE
DROP PROCEDURE
EXECUTE PROCEDURE
DDL - Data Definition Language

back to top of page
<< ALTER EXTERNAL FUNCTION | FB 2.0 Language Reference | ALTER SEQUENCE >>