57
DEBUG_EXTPROC

The DEBUG_EXTPROC package enables you to start up the extproc agent within a session. This utility package can help you debug external procedures.

Requirements

Your Oracle account must have EXECUTE privileges on the package and CREATE LIBRARY privileges.

Note: DEBUG_EXTPROC works only on platforms with debuggers that can attach to a running process.

Installation Notes

To install the package, run the script DBGEXTP.SQL.

• Install/load this package in the Oracle USER where you want to debug the 'extproc' process.

• Ensure that you have execute privileges on package DEBUG_EXTPROC

  SELECT SUBSTR(OBJECT_NAME, 1, 20) 
  FROM USER_OBJECTS 
  WHERE OBJECT_NAME = 'DEBUG_EXTPROC';
  

• You can install this package as any other user, as long as you have EXECUTE privileges on the package.

Using DEBUG_EXTPROC

Usage Assumptions

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.

Usage Notes

• Start a brand new oracle session through SQL*Plus or OCI program by connecting to ORACLE.

• Execute procedure DEBUG_EXTPROC.STARTUP_EXTPROC_AGENT to startup the extproc agent in this session; e.g., execute DEBUG_EXTPROC.STARTUP_EXTPROC_AGENT; Do not exit this session, because that terminates the extproc agent.

• Determine the PID of the extproc agent that was started up for this session.

• Using a debugger (e.g., gdb, dbx, or the native system debugger), load the extproc executable and attach to the running process.

• Set a breakpoint on function 'pextproc' and let the debugger continue with its execution.

• Now execute your external procedure in the same session where you first executed DEBUG_EXTPROC.STARTUP_EXTPROC_AGENT

• Your debugger should now break in function 'pextproc'. At this point in time, the shared library referenced by your PL/SQL external function would have been loaded and the function resolved. Now set a breakpoint in your C function and let the debugger continue its execution.

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)

• The debugger should now break in your C function. Its assumed that you had built the shared library with debugging symbols.

• Now proceed with your debugging.