1. Database Administrator's Reference
  2. Developing Applications for Windows
  3. About Debugging External Procedures
  4. Using Package DEBUG_EXTPROC

Using Package DEBUG_EXTPROC

To help you debug external procedures, PL/SQL provides the utility package DEBUG_EXTPROC.

To install the package, run the script dbgextp.sql, which you can find in the PL/SQL demo directory.

To use the package, follow instructions in dbgextp.sql. Your Oracle Database account must have EXECUTE privileges on the package and CREATE LIBRARY privileges.

To debug external procedures:

  1. From Windows Task Manager, in the Processes dialog, select ExtProc.exe.
  2. Right click, and select Debug.
  3. Click OK in the message window.

    If you have built your DLL in a debug fashion with Microsoft Visual C++, then Visual C++ is activated.

  4. In the Visual C++ window, select Edit > Breakpoints.

    Use the breakpoint identified in dbgextp.sql in the PL/SQL demo directory.

    See Also:

Parent topic: About Debugging External Procedures