Debug Disconnect

[Jim St.Cyr]

Is there a definitive answer to what causes a disconnect to occur when attempting to compile a package? Unchecking 'Add debug information when compiling' resolves the disconnect but reduces debugging efficiency.

- Using PSD 7.0.3.1123 the problem occurs going against both 9i (9.0.1.4) and 10g (10.2.0.1).

- Problem is sporadic. Last friday I was compiling fine with 'Add debug...' enabled. This morning, with no chanages made to the package, I get the error.

 

[Marco Kalter]

Any definitive answer about this will have to come from Oracle Support, since this is an Oracle Server bug. You can reproduce it in SQL*Plus as follows:

SQL> alter session set plsql_debug=true;
SQL> @yourpackage.sql