Quick Search:
 
 The Oracle DEBUG_EXTPROC Function      [Return To Index] Jump to:  

Term: DEBUG_EXTPROC

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

Notes
1. The user must hold EXECUTE privilege on DEBUG_EXTPROC and CREATE LIBRARY privileges.
2. User (not SYS user) has to run the script DBGEXTP.SQL to create the package. Successful creation of the package can be queried from USER_OBJECTS table.

Subprograms

DEBUG_EXTPROC consists of one subprogram STARTUP_EXTPROC_AGENT procedure which is used to launch the external procedure agent, thereby discovering its corresponding Process Id. This ID is later used in the debugger by aligning it with a running process.

Example Syntax
DEBUG_EXTPROC.STARTUP_EXTPROC_AGENT;

Example

SQL> execute debug_extproc.startup_extproc_agent; 

PL/SQL procedure successfully completed.
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org