Skip to Main Content

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!

Connection terminated before completion of stored procedure

557705Jan 23 2007 — edited Jan 23 2007
Hello 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 20 2007
Added on Jan 23 2007
3 comments
1,733 views