Using Acceptable Legal PL/SQL Expressions in the Debugger

If you are debugging PL/SQL, then you can use PL/SQL expressions in the Watches window, Inspector window, Breakpoint conditions, and Breakpoint Log expressions.

The following are examples of acceptable legal PL/SQL expressions that you can use in the debugger:

Simple variable name:

counter

Field access:

myrecord.Dept_No

Table element:

mytable(3)

Comparison operation:

myrecord.Dept_No = 100

mytable(3) > 7

counter IS NULL

counter IS NOT NULL

employee.salary BETWEEN 25000 AND 50000

Arithmetic operation:

counter * size

x + y + z

Logical operation:

employee.exempt AND employee.active

employee.exempt OR employee.active

Package variable name:

$Oracle.Package.SCOTT.MyPackage.MyVariable

Fully-qualified Package name:

$Oracle.Package.SCOTT

PackageBody variable name:

$Oracle.PackageBody.SCOTT.MyPackage.MyVariable

Fully-qualified PackageBody name:

$Oracle.PackageBody.SCOTT

Related topics

Debugging PL/SQL and Java Stored Procedures

Using Acceptable Legal Java Expressions in JDeveloper

Copyright © 1997, 2004, Oracle. All rights reserved.