Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Remote Debugger - Breakpoints ignored?

311747Feb 8 2013 — edited Feb 11 2013
I am trying to remote debug a package using SQL Developer.

I've added the following line to the package:
DBMS_DEBUG_JDWP.CONNECT_TCP( '132.123.123.123', 4000 );
Compile for debug
add some break points.
I start a Debug Listener on port 4000.
Then call the procedure from another session.

A debugger session opens up in SQL Developer, but the procedure never stops at any of the break points. It simply runs to the completion w/o stopping.

There is a debugger window w/ the following message:
Debugger accepted connection from database on port 4000.

but no stack. The procedure finished normally.

Has anyone else seen where the breakpoints are ignored in a remote debugger session?
Thanks much!

Versions info:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
Oracle SQL Developer (3.2.20.09)

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 11 2013
Added on Feb 8 2013
#plsql, #sql-developer, #sqldeveloper
4 comments
1,119 views