Note
This view is available starting with V4.3.5 for V4.3.x.
This view is available starting with V4.2.5 for V4.2.x.
Purpose
The USER_PLSQL_TYPES view is used to display the general information of a package type under the current user. The type in a package is displayed in this view only when the package is compiled successfully.
Applicability
This view is available only in the OceanBase Database Oracle mode.
Columns
| Column | Type | Nullable | Description | |||||
|---|---|---|---|---|---|---|---|---|
| TYPE_NAME | VARCHAR2(136) | NO | Type | |||||
| PACKAGE_NAME | VARCHAR2(128) | YES | The name of the package to which the PL/SQL type belongs. | |||||
| TYPE_OID | RAW(16) | NO | An object ID of the PL/SQL type. | TYPE_OID | RAW(16) | NO | An object ID of the PL/SQL type. | |
| TYPECODE | VARCHAR2(58) | NO | PL/SQL type code. | |||||
| ATTRIBUTES | NUMBER(38) | NO | The number of attributes of a PL/SQL type. | |||||
| CONTAINS_PLSQL | VARCHAR2(3) | NO | Indicates whether the PL/SQL type contains PL/SQL code. |
Sample query
This query retrieves overall information on package types for the current user.
obclient> SELECT * FROM USER_PLSQL_TYPES;
References
- View the overall information about package types: ALL_PLSQL_TYPES.
- Query the overall information about package types in the current tenant: DBA_PLSQL_TYPES.