The DEBUG_EXTPROC package enables you to start up the extproc agent within a session. This utility package can help you debug external procedures.
1. The user must hold EXECUTE privilege on DEBUG_EXTPROC and CREATE LIBRARY privileges.
2. User (not SYS user) has to run the script DBGEXTP.SQL to create the package. Successful creation of the package can be queried from USER_OBJECTS table.
DEBUG_EXTPROC consists of one subprogram STARTUP_EXTPROC_AGENT procedure which is used to launch the external procedure agent, thereby discovering its corresponding Process Id. This ID is later used in the debugger by aligning it with a running process.
SQL> execute debug_extproc.startup_extproc_agent;
PL/SQL procedure successfully completed.