Which two statements are true about the usage of the DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure?
(Choose two.)
A.
You can describe remote objects.
B.
You can describe anonymous PL/SQL blocks.
C.
You can describe a stored procedure, stored function, packaged procedure, or packaged function.
D.
You can obtain information about the position, name, and data type of the arguments of a procedure
Explanation:
SyntaxDBMS_DESCRIBE.DESCRIBE_PROCEDURE(
object_name IN VARCHAR2,
reserved1 IN VARCHAR2,
reserved2 IN VARCHAR2,
overload OUT NUMBER_TABLE,
position OUT NUMBER_TABLE,
level OUT NUMBER_TABLE,
argument_name OUT VARCHAR2_TABLE,
datatype OUT NUMBER_TABLE,
default_value OUT NUMBER_TABLE,
in_out OUT NUMBER_TABLE,
length OUT NUMBER_TABLE,
precision OUT NUMBER_TABLE,
scale OUT NUMBER_TABLE,
radix OUT NUMBER_TABLE,
spare OUT NUMBER_TABLE);
C, D
http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_descrb.htm#BAJJJGJH
C, D
C,D