Skip Headers

PL/SQL Packages and Types Reference
10g Release 1 (10.1)

Part Number B10802-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

122
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.

This chapter contains the following topics:


Using DEBUG_EXTPROC


Security Model

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


Operational Notes

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

Having installed the package, proceed accordingly:

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)


Rules and Limits


Note:

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



Summary of DEBUG_EXTPROC Subprograms

Table 122-1  DEBUG_EXTPROC Package Subprograms
Subprogram Description

STARTUP_EXTPROC_AGENT Procedure

Starts up the extproc agent process in the session


STARTUP_EXTPROC_AGENT Procedure

This procedure starts up the extproc agent process in the session.This enables you to get the PID of the executing process. This PID is needed to be able to attach to the running process using a debugger.

Syntax

DEBUG_EXTPROC.STARTUP_EXTPROC_AGENT;