Debug PL/SQL Stored Procedure

745188

I am using JDevloper 10.1.3.4. As I am steppping through a servlet in debug and a call is made to a pl/sql stored procedure is it possible to seamlessly (or otherwise) have the debugger step into that pl/sql procedure and then step back into the servlet when exiting? I can run a pl/sql proc in debug seperately but it would be great if it could be done in line with the servlet call.

Shay Shmeltzer-Oracle

Something like this should work:
http://blogs.oracle.com/shay/2006/12/debugging_java_and_plsql_toget.html

745188

thanks a ton! I'll give this a try. Does the dbs_debug_jdwp.connect_tcp(ip,port) have to be in the called procedure?