Home » SQL & PL/SQL » Client Tools » compile debug with sql navigator v4.x
compile debug with sql navigator v4.x [message #48845] Tue, 21 December 2004 09:17 Go to next message
Goran Jednak
Messages: 3
Registered: December 2004
Junior Member
Hello, I am not able to compile any database object in debug mode from SQL Navigator version 4.x. The error message I am getting is ORA-03113: end-of-file on communication channel and then I am asked to reconnect to DB or simply SQL Navigator hangs indefinitely. I am able to perform the same task from SQL Plus. We are running version 9.2.0.2.0. Thanks.
Re: compile debug with sql navigator v4.x [message #48847 is a reply to message #48845] Tue, 21 December 2004 22:52 Go to previous message
Scott Cowan
Messages: 15
Registered: February 2004
Junior Member
Things to try,

1) Are you using the same user account for sqlplus ??
If not check ,User account has the system privilege "DEBUG ANY PROCEDURE".

2) Search for tnsnames.ora files on your pc incase
sql navigator is picking up a different one from
sqlplus.

3) Write a one line procedure and try debugging it, if this works then use process of elimination on what is breaking the debugger.

Cheers

Scott
Previous Topic: i sql
Next Topic: DEFINE in TOAD vs SQLPLUS
Goto Forum:
  


Current Time: Tue Aug 04 14:57:57 CDT 2020