Debugging PL/SQL and Java Stored Procedures Prerequisites

When debugging PL/SQL in JDeveloper, you require the Oracle8i Release 8.1.7 database or greater. For Java stored procedure debugging in JDeveloper, you require the Oracle9i Release 2 database.

Refer to the appropriate section below for additional prerequisite information:

PL/SQL Programs Prerequisites
Java Stored Procedures Prerequisites

PL/SQL Programs Prerequisite

Ensure that the following prerequisites have been met before performing PL/SQL debugging:

Your database user account must have certain privileges.

Oracle8i or Oracle9i Release 1 databases

No special privileges required for objects in the user's schema. However, for debugging objects in another user's schema, you require the privilege:
CREATE ANY PROCEDURE

Oracle9i Release 2 database

DEBUG ANY PROCEDURE
DEBUG CONNECT SESSION
The PL/SQL code must be compiled in INTERPRETED mode. You cannot debug PL/SQL code that is compiled in NATIVE mode. You set this mode in the database's init.ora file. See the Oracle database documentation for more information about this file.
If you do not have an active workspace and project, the debugger will use the Default Project Properties. However, it is recommended that you create a workspace and a project that you will use when you debug PL/SQL. In the T ools | Project Properties - Runner page, you should ensure that the Attempt to Run Active File Before Default check box is selected (default setting). This will instruct the debugger to run the active file (for example a PL/SQL procedure selected in the Navigator or open the active file in the Code Editor) when you start debugging.
PL/SQL objects must be compiled with the DEBUG option enabled. Choose one of these techniques to accomplish this task:
- Ensure that the Generate PL/SQL Debug Information is selected in T ools | Preferences - Database Connections, then from JDeveloper create or recompile the objects you want to debug.
- In SQL*Plus, execute ALTER SESSION SET PLSQL_DEBUG = true , then create or recompile the object you want to debug.
- In SQL*Plus, execute ALTER <procedure, function, package> <name> COMPILE DEBUG;

Java Stored Procedure Prerequisites

Ensure that the following prerequisites have been met before performing Java stored procedures debugging:

The Java code must be deployed to the database and compiled with debug information. From JDeveloper, make sure the Include Debug Information check box is selected in Tools | Project Properties - Compiler, then deploy the Java stored procedure.
To step through a Java stored procedure, the Java source must be available in your JDeveloper project and must be consistent with what is deployed to the database.