ORA-03113: end-of-file on communication Channel

hi,
im trying to compile a long package body and it gives me this error. However when i try to compile the same package with some other client say sql * plus or sql developer it doesn't give me that error. when i checked with the udump there is a cursor dump that is happening. i don't know whether it is the error with the clients inability to handle the connection state or its a bug with the oracle server. i see many posts that says it the problem with the oracle server. if that is the case it should not compile with other clients too..

Code:
child pin: ffffffff7cf5c218, child lock: ffffffff7cf5c190, parent lock: ffffffff7cf5f3e8
 xscflg: 802264, parent handle: ffffffff7cf5cd78, xscfl2: c000400
  nxt: 1.0x00000190
Cursor frame allocation dump:
this is what i see after the package code. i got this from the udump file with name ora_1027, ora_1079 etc...
 
If a compilation causes such an error and works correctly in SQL*Plus, then I suspect a problem with the "debug information" mode. To verify this, go to Tools > Preferences > Debugger tab page, disable the "Add debug information when compiling" option, and retry the compilation.

If you are using PL/SQL Developer 6.0 or later, you can explicitly exclude specific objects from debug information. On the same debugger tab page you can add a line with the name (or owner.name) of the program unit to the "NEVER add debug info for objects" list.
 
Back
Top