SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-03114: not connected to ORACLE (Bizarre problem)

34MCA2K2May 17 2010 — edited May 19 2010

We are facing an bizarre problem in Oracle 10G. We are trying to compile a package specification. As long as there are 10 procedures(program units) in the package it compiles successfully, As soon as we add 11th program unit(come what may a simplest of procedure declaration), It disconnects the session immediately. We asked for alert logs & there is no relevant entry in alert log file.

Please find below the error: -

SQL> @D:\Package_Name.sql
ERROR:
ORA-03114: not connected to ORACLE

create or replace PACKAGE PACKAGE_NAME
*
ERROR at line 1:
ORA-03135: connection lost contact

Elapsed: 00:00:18.90
ERROR:
ORA-03114: not connected to ORACLE

Elapsed: 00:00:00.00
No errors.
SQL>

Please Help

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 16 2010

Added on May 17 2010

4 comments

1,751 views