|Oracle8i Supplied Packages Reference
DEBUG_EXTPROC package enables you to start up the extproc agent within a session. This utility package can help you debug external procedures.
Your Oracle account must have
EXECUTE privileges on the package and
CREATE LIBRARY privileges.
To install the package, run the script
SELECT SUBSTR(OBJECT_NAME, 1, 20) FROM USER_OBJECTS WHERE OBJECT_NAME = 'DEBUG_EXTPROC';
EXECUTEprivileges on the package.
This assumes that the Listener has been appropriately configured to startup an external procedures 'extproc' agent.
This also assumes that you built your shared library with debug symbols to aid in the debugging process. Please check the C compiler manual pages for the appropriate C compiler switches to build the shared library with debug symbols.
STARTUP_EXTPROC_AGENTto startup the extproc agent in this session; e.g., 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)
DEBUG_EXTPROC contains one subprogram:
STARTUP_EXTPROC_AGENT procedure. This 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.