Why won't the debbuger launch in oracle SQL developer?

Question

0.00/5 (No votes)

See more:

Hello Everybody,

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.

What I have tried:

- I have restarted the oracle server.
- I have tried to debug many others procedures, all of them have the same behavior.
- If I click on the "run" button, set the parameters and run the procedure, it will run, and give me the output variable.
- The procedure compiles without errors.
- Everything seems to be working just normal, except for debugging.

Posted 7-Apr-17 4:05am

Arthur Medeiros

Updated 7-Apr-17 10:37am

Add a Solution

Comments

CHill60 7-Apr-17 10:51am

Have you tried everything on this blog: How to Start the PL/SQL Debugger | ThatJeffSmith[^]

2 solutions

Solution 2

Hey everybody,

I appreciate your help.
I could solve the problem by changing the listener configuration.

Weird thing is that everything was working just fine, except for the debugger.

Thanks!

Posted 7-Apr-17 10:37am

Arthur Medeiros

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

bobrien100 · Accepted Answer · 2017-04-07T05:56:00

Solution 1

PL/SQL developer? Did you right click on the procedure and select add debugging info after compiling? Without debugging info, your stored proc will run when you try to debug but will zip right through it. My guess.

Posted 7-Apr-17 5:56am

bobrien100