Oracle9i Supplied PL/SQL Packages and Types Reference Release 2 (9.2) Part Number A96612-01 |
|
You can use the DBMS_DESCRIBE
package to get information about a PL/SQL object. When you specify an object name, DBMS_DESCRIBE
returns a set of indexed tables with the results. Full name translation is performed and security checking is also checked on the final object.
This package provides the same functionality as the Oracle Call Interface OCIDescribeAny
call.
This chapter discusses the following topics:
This package is available to PUBLIC
and performs its own security checking based on the schema object being described.
The DBMS_DESCRIBE
package declares two PL/SQL table types, which are used to hold data returned by DESCRIBE_PROCEDURE
in its OUT
parameters. The types are:
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
can raise application errors in the range -20000 to -20004.
|
Copyright © 2000, 2002 Oracle Corporation. All Rights Reserved. |
|