I installed pl/sql developer version 6.03.893 and tried to compile a pre-existing procedure and got this oracle error message ORA-03114:not connected to ORACLE. I checked my connection to oracle and it is fine. I am able to compile the same procedure using sqlplus. I have oracle 9.2 server and have oracle 9i client. We opened a ticket with oracle and since the procedure is compiling fine with sqlplus they seem to think it a pl/sql developer issue.
ORA-03114:not connected to ORACLE
- Thread starter arunb
- Start date
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.
Since you are using PL/SQL Developer 6.0, 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.
Since you are using PL/SQL Developer 6.0, 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.
Similar threads
- Discussion
- Discussion
