This content has been marked as final. Show 5 replies
First you need to make sure the procedure you are debugging has been compiled for debug; if it's correctly compiled you should see a small green bug over the procedure you want to debug in the navigator.1 person found this helpful
If there is no such sign the you should right click on the procedure and select the compile for debug option.
In case the procedure is already compiled for debug, and it still does not work then there may be problems connecting the debugger to the database, normally it's the database that tries to connect to your PC, so you'll have to make sure the database server can correctly identify your PC and connect to the debug port used by SQLDeveloper.
You can find various configurations for the debugger in
Tools -> Preferences -> DebuggerThe most useful preference to try here is the
Prompt for Debugger Host for Database Debuggingthis will enable a pop-up where you can enter your local IP address so the database can connect without the need to correctly identify your working PC in the network.
Also if you have firewalls you could change the port range used by the debugger to allowed ranges.
Thanks for your excellent help, I can now debug the procedures in SQL Developer.
As of now I m able to debug within SQL Developer itself but would ideally like to debug it from my Java Application which calls these PLSQL stored procedures.
So as soon as I enter some values in the Java application and try to save the data the Java Application calls the PLSQL procedure at this point I would like the debugger in SQL Developer to get activated , is this possible ? If yes please let me know how this can be done ?
Please note my Java application is not a web-based app, its a client server application.
Is there a way where I can debug the PLSQL code from the time the code gets invoked through the Java Application ?
Or is there no way possible ? Please advise.
You can definitely do this, it's called 'External' or 'Just In Time' debugging.
Barry has a nice post on the subject
Thanks , If I can make this happen this will help us a lot, I have a question though when I run the SQL Developer debugger it prompts for a URL where I enter the port number and the URL of the remote client. In my case I would like SQL Developer to pick values passed to the stored procedure from the Java Application. I invoke this Client server based Java application from Command prompt , it runs of a JBoss server locally on my PC. How can I find the URL of the JAva application, any help/ advice ?