DBMS_DESCRIBE in Oracle

DBMS_DESCRIBE: DBMS_DESCRIBE is the Oracle-supplied package to obtain information about a PL/SQL object. The package contains the DESCRIBE_PROCEDURE procedure, which provides a brief description of a PL/SQL stored procedure. It takes the name of a stored procedure and returns information about each parameter of that procedure.