D.21. RDB$PROCEDURE_PARAMETERS

RDB$PROCEDURE_PARAMETERS stores the parameters of stored procedures and their attributes. It holds one row for each parameter.

Column NameData TypeDescription

RDB$PARAMETER_NAME

CHAR(31)

Parameter name

RDB$PROCEDURE_NAME

CHAR(31)

The name of the procedure where the parameter is defined

RDB$PARAMETER_NUMBER

SMALLINT

The sequential number of the parameter

RDB$PARAMETER_TYPE

SMALLINT

Indicates whether the parameter is for input (value 0) or output (value 1)

RDB$FIELD_SOURCE

CHAR(31)

The name of the user-created domain, when a domain is referenced instead of a data type. If the name starts with the prefix RDB$, it is the name of the domain automatically generated by the system for the parameter.

RDB$DESCRIPTION

BLOB TEXT

Could store comments related to the parameter

RDB$SYSTEM_FLAG

SMALLINT

Indicates whether the parameter was defined by the system (value or greater) or by a user (value 0)

RDB$DEFAULT_VALUE

BLOB BLR

The default value for the parameter, in the binary language representation (BLR)

RDB$DEFAULT_SOURCE

BLOB TEXT

The default value for the parameter, in PSQL code

RDB$COLLATION_ID

SMALLINT

The identifier of the collation sequence used for a character parameter

RDB$NULL_FLAG

SMALLINT

Nullable state of the parameter:

NULL

nullable

1

not nullable (NOT NULL)

RDB$PARAMETER_MECHANISM

SMALLINT

Indicates how the type of the parameter was declared

0

normal (direct type use)

1

declared with TYPE OF or TYPE OF COLUMN

RDB$FIELD_NAME

CHAR(31)

The name of the column the parameter references, if it was declared using TYPE OF COLUMN instead of a regular data type. Used in conjunction with RDB$RELATION_NAME (see next).

RDB$RELATION_NAME

CHAR(31)

The name of the table the parameter references, if it was declared using TYPE OF COLUMN instead of a regular data type