Overview of DBMS_DESCRIBE

The DBMS_DESCRIBE system package is used to retrieve information about PL objects.

The DBMS_DESCRIBE procedure returns a set of index tables with results based on the specified object name. It performs fully qualified name conversion and performs a security check on the final object.

The DBMS_DESCRIBE system package has the same calling functionality as OCIDescribeAny.

DBMS_DESCRIBE Privilege Description

This system package is available for PUBLIC use and performs its own security checks based on the described schema objects.

DBMS_DESCRIBE Table Types

The DBMS_DESCRIBE system package declares two PL table types for storing the data returned by DESCRIBE_PROCEDURE in OUT parameters.

The two 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;

DBMS_DESCRIBE Exception

The DBMS_DESCRIBE package may cause the following application errors:

Overview of the DBMS_DESCRIBE Subprogram

The following table lists the DBMS_DESCRIBE subprograms supported by the current version of OceanBase Database and provides brief descriptions.