ORA-03114: not connected to ORACLE

[Ivan C.]

Greetings!

I'm having a strange problem. I get the "ORA-03114: not connected to ORACLE" while trying to compile a script that creates a procedure, from the Program Window.

I tried re-connecting, and executing the script again (right away)... The same error happens.

Running the script from SQL*Plus however presents no problems.

I was able to compile the same script yesterday, so I thought maybe the new code (I added some lines today) is causing the problem (the script is about 1400 lines long now), so I tried running the "old version" of the script... The same error (

Help, anyone?

Thank you in advance.
Ivan C.

 

[Ivan C.]

I'm not getting it anymore.

All I did was added more code. Our DBA confirms that no changes were done to the schema in question, before or after the problem.

Some other developers reported the same problem while using other "development" tools.

Please note, that the problem doesn't occur while running the script from SQL*Plus.

I hope someone finds an answer some day.

Good luck!
Ivan C.

 

[Eduardo P.]

I'm getting the same problem here.

When I tried to compile a new procedure, I got the "ORA-03113: end-of-file on communication channel" error, and when I clicked "OK" I got the "ORA-03114: not connected to ORACLE".

The strange thing is that I get the same errors on packages and procedures that was previously working fine and had no alterations! And even more strange is that the same errors occured with other developers, in other computers with other working procedures....

When I copy the procedure code, paste it on a new command window and execute, it compiles without any errors!

Any help is welcome!

Thank you,
Eduardo P.

 

[mike]

That problem started happening to me when we upgraded our database. You might try unchecking the "add debug information while compiling" preference. That worked for me anyway.

If that "fixes" it, and you need the debugger, you can try adding the debug information later. Unfortunately, the debugger locks up for me every so often making it useless. I'm sure that this is Oracle's problem, not Allround Automations.