Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unable to DEBUG stored procedure: Client or Server setup?

Status
Not open for further replies.

robz2009

Programmer
Apr 20, 2009
41
GB
We have an issue on some client PC's here that when attempting to debug a stored procedure in SQL Developer we get the following error…

Connecting to the database UAT.
Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '1*5.2*4.2*5.202', '2**9' )
ORA-30683: failure establishing connection to debugger
ORA-12535: TNS:eek:peration timed out

I have done some investigation into the ORA-30683 error and found out that this is linked to the ORA_DEBUG_JDWP parameter. The example syntax given being "SET ORA_DEBUG_JDWP=host=hostname;port=portnum" What I don’t know is how to implement this?

- Are we talking the client level or server level?
- What parameters am I passing in as hostname and port? client or server?
- Where abouts am I setting this parameter, init.ora?
- I have also read some information about the listener but again I am not sure if we are talking client or server?

If someone can help me with a step by step guide on how to "enable" debugging of Oracle stored procedures that would be helpful.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top