SMALLINT

The procedure’s unique, system-generated identifier

SMALLINT

Indicates the number of input parameters. NULL if there are none

SMALLINT

Indicates the number of output parameters. NULL if there are none

BLOB TEXT

Any text comments related to the procedure

BLOB TEXT

The PSQL source code of the procedure

BLOB BLR

The binary language representation (BLR) of the procedure code

CHAR(63)

May point to the security class defined in the system table RDB$SECURITY_CLASSES in order to apply access control limits

CHAR(63)

The username of the procedure’s Owner — the user who was CURRENT_USER when the procedure was first created. It may or may not be the username of the author.

BLOB

A metadata description of the procedure, used internally for optimization

SMALLINT

Indicates whether the procedure is defined by a user (value 0) or by the system (a value of 1 or greater)

SMALLINT

Procedure type:

1 - selectable stored procedure (contains a SUSPEND statement) 2 - executable stored procedure NULL - not known *

* for procedures created before Firebird 1.5

SMALLINT

Indicates whether the source PSQL of the stored procedure remains valid after the latest ALTER PROCEDURE modification

BLOB DEBUG_INFORMATION

Contains debugging information about variables used in the stored procedure

CHAR(63)

Engine for external functions. 'UDR' for UDR procedures. NULL for PSQL stored procedures

CHAR(255)

The exported name of the external function in the procedure library. Note, this is often not the same as RDB$PROCEDURE_NAME, which is the identifier with which the external stored procedure is declared to the database

CHAR(63)

Package name of the procedure (or NULL for a top-level stored procedure)

SMALLINT

NULL for normal (top-level) stored procedures, 0 for package procedures defined in the header, 1 for package procedures only defined in the package body.

BOOLEAN

The SQL SECURITY mode (DEFINER or INVOKER):

NULL - initial default (INVOKER) FALSE - INVOKER TRUE - DEFINER