This content has been marked as final. Show 3 replies
learned something new today
Edited by: Marwim on 28.11.2012 17:39
Removed first answer
Look at the remote debugging section in the online help. (Although I don't think the help section makes it very clear.)1 person found this helpful
Essentially you need to set up SQL Developer debugger to listen and then in the remote code you have to connect to the debugger using dbbms_debug_jdwp.connect_tcp('your sql developer workstation','debugger port'.
If you can't modify the remote code to include a call to dbms_debug_jdwp, then I'm afraid there is nothing you can do.
Edit to add:
Also make sure you have compiled for debug and that your breakpoint is on an executable line (i.e. not a declaration)
Edited by: Jim Smith on Nov 28, 2012 12:24 PM
No need to modify the remote code, you can alternatively set an OS environment variable to accomplish the same1 person found this helpful