Get information about a PL/SQL object.
Contains only one procedure: DESCRIBE_PROCEDURE
The package declares two PL/SQL table types which are used
to hold data returned by its OUT parameters.
TYPE VARCHAR2_TABLE IS TABLE OF VARCHAR2(30)
INDEX BY BINARY_INTEGER;
TYPE NUMBER_TABLE IS TABLE OF NUMBER
INDEX BY BINARY_INTEGER;
For full documentation of the packaged procedure above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"
or the book Oracle Built in Packages by Steven Feuerstein et al
“I have a lot of street smarts because of the neighbourhood I grew
up in" - Jennifer
Lopez
Related Commands:
DESC
Related Views
ALL_ARGUMENTS USER_ARGUMENTS DBA_OBJECTS ALL_OBJECTS USER_OBJECTS SYS_OBJECTS DBA_SOURCE ALL_SOURCE USER_SOURCE