Debugging Java and PL/SQL Together

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).

Comments:

Toad version 9 also allows this, all with a single debug session.

Posted by Anon on December 11, 2006 at 12:20 PM PST #

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...

Posted by Olaf Heimburger on December 11, 2006 at 06:22 PM PST #

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 :-)

Posted by Shay Shmeltzer on December 12, 2006 at 03:27 AM PST #

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?

Posted by Leonard Krpan on September 03, 2008 at 10:22 PM PDT #

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

Posted by guest on October 21, 2011 at 09:44 PM PDT #

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

Posted by kk on May 01, 2012 at 02:13 PM PDT #

Hi, demo link posted is still not working

Posted by guest on November 20, 2012 at 12:21 AM PST #

guest - see the demo linked from here:
https://blogs.oracle.com/shay/entry/remote_debugging_plsql_using_j

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

Posted by Shay on November 20, 2012 at 11:36 AM PST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

me
I'm a Director of Product Management for the Oracle Java Development Tools.
Follow me:
Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today