I am not able to step into my code...when testing, it just runs the whole procedure to the end. I want to be able to see the variables as they get set.
I have searched and found the following:
The procedure (or the package containing the procedure) might not be compiled with debug info---the checkbox for 'Add debug information' is set and I have the "Use DBA views if available" preference enabled
2) the user running the debugger is not the owner of the package/procedure
(you need the "debug any procedure" privilege to debug procedures you don't own)
Where do I find this to set it?
"debug any procedure" privilege
Thank you
I have searched and found the following:
The procedure (or the package containing the procedure) might not be compiled with debug info---the checkbox for 'Add debug information' is set and I have the "Use DBA views if available" preference enabled
2) the user running the debugger is not the owner of the package/procedure
(you need the "debug any procedure" privilege to debug procedures you don't own)
Where do I find this to set it?
"debug any procedure" privilege
Thank you