Debugging a SQL Script
This topic explains how to debug SQL scripts using debugger integrated into dbForge Studio for Oracle.
To debug a SQL script:
- Open the required script in the SQL editor.
- On the Debug menu, click Start.
- Set a breakpoint on any line of executable code.
If a statement is invalid, an error message appears in the error list, though debugging process continues. You can use different step commands of the Debug menu to trace an SQL script.
To debug an SQL script, you don’t need any special privileges, except for the privileges, required for execution of the script statements.
You can use the Watches pane to view server and session variables during SQL script debugging.
Want to Find out More?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for Oracle.
All features
Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo
If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for Oracle?