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

Part Number E25788-04
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
PDF · Mobi · ePub
ARPLS067

181 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:

ARPLS70206

Using DEBUG_EXTPROC

ARPLS70207

Security Model

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

ARPLS70208

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)

ARPLS70209

Rules and Limits

Note:

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

Summary of DEBUG_EXTPROC Subprograms

ARPLS70211Table 181-1 DEBUG_EXTPROC Package Subprograms

Subprogram Description

STARTUP_EXTPROC_AGENT Procedure

Starts up the extproc agent process in the session


ARPLS70212

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;
Reader Comment

   

Comments, corrections, and suggestions are forwarded to authors every week. By submitting, you confirm you agree to the terms and conditions. Use the OTN forums for product questions. For support or consulting, file a service request through My Oracle Support.

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

This Page

This Document

New and changed documents:
RSS Feed HTML RSS Feed PDF