X

Shay Shmeltzer's Oracle Development Tools Tips

  • December 11, 2006

Debugging Java and PL/SQL Together

Shay Shmeltzer
Director of Product Management - Oracle

A couple of people pinged me to ask if it was possible to do a "Step-into" from a Java class into a PL/SQL stored procedure while debugging.

The answer is yes if you are using JDeveloper.

The trick is to use two debug sessions - one to remote debug the PL/SQL and the other to debug the Java file.

Here is a little demo and explanation of the setup to get this working.

(you might want to press F11 while watching to get see the full screen).

 Update - the original video got removed - so this one might help = //cdn.app.compendium.com/uploads/user/e7c690e8-6ff9-102a-ac6d-e4aebca50425/f4a5b21d-66fa-4885-92bf-c4e81c06d916/File/4eaa7897cf9c184210259d7f065f9e4e/plsql_debug.html 

Join the discussion

Comments ( 11 )
  • Anon Monday, December 11, 2006
    Toad version 9 also allows this, all with a single debug session.
  • Olaf Heimburger Tuesday, December 12, 2006
    Nice demo. This was possible since JDev 9.0.2. I could do it with only one debugging session, but need to find the time to write this up...
  • Shay Shmeltzer Tuesday, December 12, 2006
    Nice to know that TOAD can do it too - but the difference is that JDeveloper is free and is also a full blown Java development environment :-)
  • Leonard Krpan Thursday, September 4, 2008
    Hi everyone,
    I am using Eclipse, I tried to follow similar steps like in the demo to try to make remote debugging work, but I get an "Invalid statement error" when the procedure that sets DBMS_DEBUG_JDWP.CONNECT_TCP is called.
    How can I make remote debugging work in Eclipse, are there any other references to this problem?
  • guest Saturday, October 22, 2011

    The link for demo is not working..Can you please give the alternate URL ?


  • kk Tuesday, May 1, 2012

    Hi, The demo link posted is not working.

    Can you please correct it, as I am not able to debug pl/sql from java using jdeveloper. I am able to debug the java part , but the debugger is not entering the pl/sql part. I am using jDeveloper studio10.1.3.5

    Appreciate your reply on this.

    thank you


  • guest Tuesday, November 20, 2012

    Hi, demo link posted is still not working


  • Shay Tuesday, November 20, 2012
  • guest Friday, April 22, 2016

    Hi,

    The demo link is not working. can you provide the working link.


  • Shay Friday, April 22, 2016

    guest, See the comment above you for a working link:

    https://blogs.oracle.com/shay/resource/viewlet/plsql_debug.html


  • guest Saturday, April 23, 2016

    The URL which you posted shows how to debug the code from PL/SQL and from java.

    https://blogs.oracle.com/shay/resource/viewlet/plsql_debug.html

    Please help me how to debug pl/sql when a java program invokes pl/sql procedure.


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.