Overview

The DBMS_DESCRIBE package queries information related to PL objects.

DBMS_DESCRIBE returns a group of index tables containing results based on the specified object names. The package performs full-name conversion and security checks for the final objects.

The DBMS_DESCRIBE package has the same call features as OCIDescribeAny.

Privileges

This package can be used by PUBLIC and performs security checks on itself based on the described schema objects.

Table types

The DBMS_DESCRIBE package declares two PL table types to store the data returned in the OUT parameter by DESCRIBE_PROCEDURE.

The two table types are as follows:

TYPE VARCHAR2_TABLE IS TABLE OF VARCHAR2(30)
    INDEX BY BINARY_INTEGER;

TYPE NUMBER_TABLE IS TABLE OF NUMBER
    INDEX BY BINARY_INTEGER;

Exceptions

The following table describes the application exceptions that may be raised by the DBMS_DESCRIBE system package.

Subprograms

The following table describes the DBMS_DESCRIBE subprograms supported by the current OceanBase Database version.