| Debugging PL/SQL with JDeveloper (merged) [message #381572] |
Sun, 18 January 2009 11:27  |
paulor
Messages: 15
Registered: December 2008
|
Junior Member |
|
|
Hello,
My question is how to debug pl/sql database procedures, functions and packages. I set priviliges for my databse user like DEBUG ANY PROCEDURE and DEBUG CONNECT SESSION, moreover I set in init.ora file for database instance parameter plsql_debug=TRUE, but whenever I clicked debug on selected database procedure (in database connections tab) I got message :
Connecting to the database TEST.
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '192.168.42.203', '3986' )
Debugger accepted connection from database on port 3986.
and although I set breakpoint on many lines of code, it never halts. Every help will be appreciated.
|
|
|
|
| Problem with debugging PL/SQL code in JDeveloper [message #381686 is a reply to message #381572] |
Mon, 19 January 2009 04:33  |
paulor
Messages: 15
Registered: December 2008
|
Junior Member |
|
|
Hello,
My question is how to debug pl/sql database procedures, functions and packages. I set priviliges for my databse user like DEBUG ANY PROCEDURE and DEBUG CONNECT SESSION, moreover I set in init.ora file for database instance parameter plsql_debug=TRUE, but whenever I clicked debug on selected database procedure (in database connections tab) I got message :
Connecting to the database TEST.
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '192.168.42.203', '3986' )
Debugger accepted connection from database on port 3986.
and although I set breakpoint on many lines of code, it never halts. Every help will be appreciated.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
