Reputation: 456
I have come here after searching in many different websites for a problem like the one I am facing.
I have this huge procedure in an Oracle Database which I need to debug to find an error.
After opening the procedure in Oracle SQL developer, I click on the gear icon, and "compile for debug" right after. Then I just click in the bug icon to start debugging.
On the bottom right of SQl developer screen appears a launching bar, but nothing else happens. In the connections section, where you can see the list of procedures, tables, etc... a green arrow appears before the name of the procedure I am trying to debug. It seems like it is preparing to start debugging, but it actually never starts. Below you can see a screenshot I took showing the issue.
Screenshot showing the procedure I am trying to debug
Here a screenshot of the "statement section" after clicking on "compile for debug"
What I have tried:
Upvotes: 1
Views: 2207
Reputation: 456
I think I have just solved it. After posting this question I started changing some parameters in the Listener. I ended up shutting down the listener, and it took me almost 3 hours to reconfigure it. The listener is working now (and it was working before), I decided to test the debugger again. Now it is debugging!!! Finally, now let me debug that HUGE procedure! Thank you very much guys!
Upvotes: 1