RDB$PROCEDURE PARAMETERS

Go Up to System Tables

RDB$PROCEDURE_PARAMETERS stores information about each parameter for each of a database’s procedures.

RDB$PROCEDURE_PARAMETERS

Column name	Datatype	Length	Description
RDB$PARAMETER_NAME	CHAR	67	Parameter name
RDB$PROCEDURE_NAME	CHAR	67	Name of the procedure in which the parameter is used
RDB$PARAMETER_NUMBER	SMALLINT		Parameter sequence number
RDB$PARAMETER_TYPE	SMALLINT		Parameter data type Values are: 0 = input 1 = output
RDB$FIELD_SOURCE	CHAR	67	Global column name
RDB$DESCRIPTION	BLOB		Subtype Text: User-written description of the parameter
RDB$SYSTEM_FLAG	SMALLINT		Indicates whether the parameter is: User-defined (value of 0) System-defined (value greater than 0)