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.



Leave a Reply 4

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


gelete

gelete

C, D

The procedure DESCRIBE_PROCEDURE provides a brief description of a PL/SQL stored procedure.

An incorrectly specified OBJECT_NAME can result in one of the following exceptions:
ORA-20000 – A package was specified.
You can only specify a stored procedure, stored function, packaged procedure, or packaged function.
ORA-…