Arturio
Arturio

Reputation: 456

Why won't oracle SQL developer launch debugger?

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"

statement section

What I have tried:

Upvotes: 1

Views: 2207

Answers (1)

Arturio
Arturio

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

Related Questions