Debugging Oracle Triggers, Stored Procedures and Functions

Oracle PL/SQL Debugger is a reliable tool that offers step-by-step code execution, breakpoints, watches, a call stack, a variables evaluation mechanism to automate debugging of Oracle stored functions and procedures. It automates all time-consuming tasks connected with debugging and provides full code control.

Debug any code in a snap

You can freely debug procedures, functions, and even triggers. Debugging complicated database deployment scripts becomes a snap.

Using Oracle debugger, you will be able to set visual breakpoints in your code with the click of a mouse, step through your code line by line, watch variables as they change their values, and so on.

Oracle PL/SQL Debugger - General View

Keep the original logic of procedure execution

Manual debugging or a tool that is not advanced or reliable enough mostly affects an original execution process and even the procedures logic. So instead of fixing the errors, you double them and get spoiled procedures. Oracle debugger, provided in dbForge Studio, knows how to escape this and help you produce error-free code.

Take full control over code execution

Oracle SQL debugger offers full code execution control that includes:

  • Full support of step-by-step code execution (Step Into, Step Out, Step Over)
  • Breakpoints to fully control code execution
  • Call stack with capability to switch between frames
  • Integrated variables evaluation mechanism

Get everything to enjoy debugging

Oracle debugger, provided in dbForge Studio, has a convenient debugger interface on a level with the modern software development tools like Microsoft Visual Studio. Working in a familiar environment with convenient features makes debugging stored routines and functions no other than an easy task.

dbForge Studio for Oracle

Multifunctional Oracle GUI

Availability in the editions of dbForge Studio for Oracle


PL/SQL debugger