|PL/SQL Packages and Types Reference
10g Release 1 (10.1)
Part Number B10802-01
DEBUG_EXTPROC package enables you to start up the extproc agent within a session. This utility package can help you debug external procedures.
This chapter contains the following topics:
Your Oracle account must have
EXECUTE privileges on the package and
CREATE LIBRARY privileges.
To install the package, run the script
EXECUTEprivileges on the package.
Having installed the package, proceed accordingly:
STARTUP_EXTPROC_AGENTto startup the extproc agent in this session; for example, execute
STARTUP_EXTPROC_AGENT; Do not exit this session, because that terminates the extproc agent.
Because PL/SQL loads the shared library at runtime, the debugger you use may or may not automatically be able to track the new symbols from the shared library. You may have to issue some debugger command to load the symbols (for example, 'share' in gdb)
Starts up the extproc agent process in the session
This procedure starts up the extproc agent process in the session.This enables you to get the PID of the executing process. This PID is needed to be able to attach to the running process using a debugger.