D.22 RDB$PACKAGES

RDB$PACKAGES stores the definition (header and body) of SQL packages.

Column Name Data Type Description
RDB$PACKAGE_NAME CHAR(63) Name of the package
RDB$PACKAGE_HEADER_SOURCE BLOB TEXT The PSQL sourcecode of the package header
RDB$PACKAGE_BODY_SOURCE BLOB TEXT The PSQL sourcecode of the package body
RDB$VALID_BODY_FLAG SMALLINT Indicates whether the body of the package is still valid. NULL or 0 indicates the body is not valid.
RDB$SECURITY_CLASS CHAR(63) May reference a security class defined in the table RDB$SECURITY_CLASSES, in order to apply access control limits to all users of this package
RDB$OWNER_NAME CHAR(63) The user name of the user who created the package originally
RDB$SYSTEM_FLAG SMALLINT Flag: 0 - user-defined 1 or higher - system-defined
RDB$DESCRIPTION BLOB TEXT Optional description of the package (comment)
RDB$SQL_SECURITY BOOLEAN The SQL SECURITY mode (DEFINER or INVOKER): NULL - initial default (INVOKER) FALSE - INVOKER TRUE - DEFINER