Which two statements are true about the usage of the DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure?

Which two statements are true about the usage of the DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure?
(Choose two.)

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:
Syntax

DBMS_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);

 



Leave a Reply 3

Your email address will not be published. Required fields are marked *