I have a somehow strange behaviour with the debugger of the latest SQL Developer.
- SQL Developer 22.214.171.124 (Build Main 14.48) 64bit (the bundled Version with JDK 1.7u45)
- Windows7 Professional SP1 64bit
- Oracle Database 10.2.0.5 64bit on Windows with the last CPU bundle applied
For testing purposes I have created a small package to debug:
create or replace PACKAGE DEBUGTESTPACK AS procedure debugme; END DEBUGTESTPACK;
create or replace PACKAGE BODY DEBUGTESTPACK AS procedure debugme AS n number; BEGIN n := 3; n := 5; END debugme; END DEBUGTESTPACK;
I have installed VirtualBox and VMWare player, so I used the setting "Prompt for debugger host for database debugging" under tools => preferences => debugger.
If I try to debug the above package SQL Developer doesn't show me the dialog where I am supposed to enter the IP address of my Machine but simply adds a process under the processes window with the IP address of the (coincidentally I guess) correct adapter, but does nothing whatsoever. I don't get any output in the messages window. If I uncheck the "Prompt for debugger...." checkbox in the settings the behaviour is exactly the same. As a test I even disabled all the Virtual network adapters to no avail.
The very same works against DB 126.96.36.199, and interestingly enough against a 10.2.0.5 32bit Linux Database running on my VirtualBox (the patchlevel between the two 10gR2 databases is different though; not sure which patches I applied to the 10gR2 linux database, I can take a look if needed); the dialog shows up as expected, and if I enter the correct IP I am able to debug.
If I try to debug the very same procedure with SQL Developer 3.2.2.09 on the first database it works, so I guess this shouldn't be any network configuration / grant issue.
thanks and regards,