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:

   • ORACLE_HOME\rdbms\extproc\readme.doc (explains how to run the sample and provides debugging advice)

   • Oracle Database PL/SQL Language Reference

   • Oracle Database Java Developer's Guide

   • Oracle Database Development Guide for more information about "Calling External Procedures"

   • Oracle Database Data Cartridge Developer's Guide