Connection terminated before completion of stored procedure
557705Jan 23 2007 — edited Jan 23 2007Hello Frendz
While executing the Stored Procedure on Oracle 9i,
ORA-03114 problem occured before completion of stored procedure.
SQL> exec SIMPLIFYSHORTERROADLINKS_903
ERROR:
ORA-03114: not connected to ORACLE
BEGIN SIMPLIFYSHORTERROADLINKS_903; END;
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Elapsed: 00:31:24.03
i.e. Oracle connection terminated, before completion of stored procedure.
I rebooted the system, shutdown immediate and start up the oracle database,
rebuild the indexes and analyze the tables also. but still the problem persists.
The same problem is coming with other stored procedures also.
Pls suggest me, Why this problem is coming and How to resolve it ?
Thanks in advance
With Regards
Rahul