Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceSystem Tables → RDB$PROCEDURE_PARAMETERS
Firebird Firebird Prev: RDB$PROCEDURESFirebird 2.5 Language ReferenceUp: System TablesNext: RDB$REF_CONSTRAINTS

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(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 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(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

Prev: RDB$PROCEDURESFirebird 2.5 Language ReferenceUp: System TablesNext: RDB$REF_CONSTRAINTS
Firebird 2.5 Language ReferenceFirebird 2.5 Language ReferenceSystem Tables → RDB$PROCEDURE_PARAMETERS