Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle DEBUG_EXTPROC Function      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 293 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?