Choose your SQL server:
AnySQL
MySQL
MS SQL Server
PostgreSQL
Oracle
SQL Anywhere
DB2
SQLite
Firebird
MaxDB

Subscribe to our newsletter

Oracle Maestro online help

Prev  Return to chapter overview Next 

PL/SQL Debugger

The PL/SQL Debugger tool allows you to debug PL/SQL code such as procedures and functions (both stand-alone and packaged) using traditional debugging features such as setting breakpoints, viewing variable values, and examining the call stack.

 

To start working with the debugger, choose the Tools | PL/SQL Debugger main menu item. You can also use the corresponding link at the Navigation bar of the Procedure/Function Editor or select the appropriate command from the object pop-up menu in the Explorer tree.

 

Note: To debug a function/procedure with nested ones, compile them with debug information in advance. Procedures/functions/packages that were compiled in this way have differing object icon in the Explorer tree.

Note: You can also debug an anonymous PL/SQL block. Just open PL/SQL Debugger and paste/enter the script.

 

 

 

 



Prev  Return to chapter overview Next