Printable View
Hi
I am using plsql developer,I know there is a debug step by step execution buttion for step by step execution.
But it is in disabled state in my tool,When i clicked on it for the first time the error message was --insufficient priviledges.
Now it always stays in disable state..
Kindly help.
Thanks
While I have never used pl/sql developer, Doesn't debugging a stored procedures rely on compiling stored procedures with debug?
No,I don't think so.For compilation there is separate option in this tool
for execution there are two options
1- normal way execute ditrectly like exec procedure_name or press the execute button
2-To press the debug execute button which will take you inside the proc and show values in each step.
If anyone know how to enable it,please let me know.Thanks
As far as I know, it is not possible to debug a PL/SQL package in normal compiled mode. It has to be compiled in INTERPRETED mode to be debugged. My *guess* is that PL/SQL developer is doing this for you behind the scenes. My further guess is that it is trying to do this as the user you are connecting with. It is either trying to ALTER PACKAGE x COMPILE DEBUG or it is trying to do an ALTER SESSION/SYSTEM to set PLSQL_DEBUG to true. In either case, I'm guessing that your user simply does not have the proper grants to be able to do that.
to execute the procedure_name, press the left button of mouse.
click in the 'test',
down you can pass the parameters and press F9 to start the debugger
to execute step by setp press (ctrl-n) "step into"