Each row represents a dependency of a package on some other object. The package depends on the object of type BTYPE of name BNAME, so a change to the object affects the package.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
PKGSCHEMA | VARCHAR (128) | Schema name of the package. | |
PKGNAME | VARCHAR (128) | Unqualified name of the package. | |
BINDER | VARCHAR (128) | Binder of the package. | |
BINDERTYPE | CHAR (1) |
|
|
BTYPE | CHAR (1) | Type of object on which there is a dependency. Possible values
are:
|
|
BSCHEMA | VARCHAR (128) | Schema name of an object on which the package depends. | |
BMODULENAME | VARCHAR (128) | Y | Unqualified name of the module to which the object on which a dependency belongs. The null value if not a module object. |
BNAME | VARCHAR (128) | Unqualified name of an object on which the package depends. | |
BMODULEID | INTEGER | Y | Identifier for the module of the object on which there is a dependency. |
TABAUTH | SMALLINT | Y | If BTYPE is 'O', 'S', 'T', 'U', 'V', 'W', or 'v', encodes the privileges that are required by this package (SELECT, INSERT, UPDATE, or DELETE). |
VARAUTH | SMALLINT | Y | If BTYPE is 'v', encodes the privileges that are required by this package (READ or WRITE). |
UNIQUE_ID | CHAR (8) FOR BIT DATA | Identifier for a specific package when multiple packages having the same name exist. | |
PKGVERSION | VARCHAR (64) | Y | Version identifier for the package. |
Note:
|