This example demonstrates how to debug Oracle stored procedure by stepping into the stored procedure. It also illustrates different debugging techniques such as setting breakpoints, viewing data items, and so on.
In this topic, some sample database objects are used for demonstrating how to work with the dbForge Fusion Debugger. Use scripts specified in this topic to create necessary objects in your test database.
Database Procedure
Use the script below to create the procedure that takes two input parameters: DateFrom and DateTo. Based on these input parameters the table fills up with data.
Assume that you need to get Time Sheet for a specific time period. To do this, execute the FillSchedule procedure:
Enter input parameters.
Note
Actual document look may slightly vary from the above image, depending on the product you use.
A quick look through the code gives you nothing and you have no other choice but to start the debugger.
To start debugging the stored procedure:
You can see that the yellow arrow identifies the stack frame where the execution pointer is currently located.
Click Retrieve Data from the shortcut menu.
dbForge Fusion displays the result table.
Note
Place the mouse pointer over a variable to see its value.
As you see, the Debugger for Oracle is a very simple and powerful tool to use. You can use different debugging techniques to achieve successful results.