Skip Headers
Oracle® Database PL/SQL Packages and Types Reference
10g Release 2 (10.2)

Part Number B14258-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
Contact Us

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

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

SELECT SUBSTR(OBJECT_NAME, 1, 20) 
    FROM USER_OBJECTS 
    WHERE OBJECT_NAME = 'DEBUG_EXTPROC';

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 133-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;