D.25 RDB$PROCEDURE_PARAMETERS

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

Column Name Data Type Description
RDB$PARAMETER_NAME CHAR(63) Parameter name
RDB$PROCEDURE_NAME CHAR(63) 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(63) 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 The flag indicating whether NULL is allowable
RDB$PARAMETER_MECHANISM SMALLINT Flag: indicates how this parameter is passed: 0 - by value 1 - by reference 2 - by descriptor 3 - by BLOB descriptor
RDB$FIELD_NAME CHAR(63) 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(63) The name of the table the parameter references, if it was declared using TYPE OF COLUMN instead of a regular data type
RDB$PACKAGE_NAME CHAR(63) Package name of the procedure (or NULL for a top-level stored procedure)