December 2002
Intermediate to advanced
928 pages
85h 29m
English
PROCEDURE DBMS_DESCRIBE.DESCRIBE_PROCEDURE
(object_name IN VARCHAR2,
reserved1 IN VARCHAR2,
reserved2 IN VARCHAR2,
overload OUT DBMS_DESCRIBE.NUMBER_TABLE,
position OUT DBMS_DESCRIBE.NUMBER_TABLE,
level OUT DBMS_DESCRIBE.NUMBER_TABLE,
argument_name OUT DBMS_DESCRIBE.VARCHAR2_TABLE,
datatype OUT DBMS_DESCRIBE.NUMBER_TABLE,
default_value OUT DBMS_DESCRIBE.NUMBER_TABLE,
in_out OUT DBMS_DESCRIBE.NUMBER_TABLE,
length OUT DBMS_DESCRIBE.NUMBER_TABLE,
precision OUT DBMS_DESCRIBE.NUMBER_TABLE,
scale OUT DBMS_DESCRIBE.NUMBER_TABLE,
radix OUT DBMS_DESCRIBE.NUMBER_TABLE,
spare OUT DBMS_DESCRIBE.NUMBER_TABLE);
Returns information about the parameters and RETURN type (if a function) of the specified object (procedure or function) in a set of PL/SQL tables, whose types are described in the same package.