The only consideration to make is that we need to remove the blank space within the concatenation operator (highlighted in yellow) because if we do not, the code will show error when saving. We select Debugging a Procedure or Function Tutorial to see the loopproc procedure code and store it in our schema.ĬREATE OR REPLACE PROCEDURE loopproc (inval NUMBER)ĭBMS_OUTPUT.put_line ('TOTAL IS: ' || total) We select from the Menu Help -> Contents and in the Search box we enter loopproc, which is a very simple process without dependencies that allows us to perform the tests.

Grant DEBUG CONNECT SESSION to Loopproc Procedureįor the demonstration of how to debug PL/SQL code, we are going to use the sample code included in the tool.

In addition, we must have the privilege DEBUG CONNECT SESSION or Oracle will not allow us to use DBMS_DEBUG.

Then the version of Oracle Probe API that we have is 2.2. Then, we execute the following anonymous PL/SQL block in the SQL Editor with an enabled DBMS output window tab:ĭbms_debug.probe_version(probe_major_ver, probe_minor_ver) ĭbms_output.put_line('MAJOR=' || probe_major_ver) ĭbms_output.put_line('MINOR=' || probe_minor_ver)

Know which version of Probe API we have within our schema.

Ensure that there is a package called DBMS_DEBUG in the SYS schema.

To verify the version of Oracle Probe API, we must do the following:

To debug PL/SQL code using Toad for Oracle and in all Oracle databases, we must first have installed Oracle Probe API v2.0 or later. Minimum Requirements from Oracle Databases to use Toad’s code debugging In addition, we will work with the Toad Auto Debugger that inserts and removes output commands (DBMS_OUTPUT) for all expressions that are within our PL/SQL code. In this article we will learn how Toad for Oracle can help us debug PL/SQL code in very simple ways, allowing us to go through the code a line at a time, view variable content, start or stop execution of code, step in or out of called PL/SQL routines (such as functions and other called procedures) and finally, change the contents of a variable during execution.

Toad for oracle