PL/SQL Debugging Basics

“ If debugging is the process of removing software bugs, then programming must be the process of putting them in. ”

As put by Edsger Dijkstra, debugging is more important than mere programming to ensure the given code block works as expected. Being a developer, I tend to debug as often as I code. But similar is not the case when I am writing scripts. And I am not sure why. So, for this post, I am going to outline the steps involved and issues encountered while debugging PL/SQL scripts using SQL Developer tool.

First of all. the application developer must be granted the following privileges by a security subprogram to debug a PL/SQL subprogram.

– DEBUG ANY PROCEDURE

– DEBUG CONNECT SESSION Continue reading