Home » SQL & PL/SQL » SQL & PL/SQL » ORA-03113 end-of-file on communication channel (oracle 10 g)
ORA-03113 end-of-file on communication channel [message #572837] Tue, 18 December 2012 01:32 Go to next message
hemant_khandare
Messages: 72
Registered: November 2011
Member
hi all,

M getting ORA-03113 end-of-file on communication channel while calling my custom procedure.
please help.
attaching code of procedure.

thanks in advance
  • Attachment: proc.txt
    (Size: 6.85KB, Downloaded 85 times)
Re: ORA-03113 end-of-file on communication channel [message #572839 is a reply to message #572837] Tue, 18 December 2012 01:49 Go to previous messageGo to next message
Michel Cadot
Messages: 60008
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink/MOS and/or call Oracle support
Have a look at alert.log and trace files.
You can also read this article: Troubleshooting Internal Errors.

Regards
Michel
Re: ORA-03113 end-of-file on communication channel [message #572876 is a reply to message #572839] Tue, 18 December 2012 06:25 Go to previous message
cookiemonster
Messages: 11285
Registered: September 2008
Location: Rainy Manchester
Senior Member
And remove this from your code:
exception 
  when others then
      null;

read WHEN OTHERS
Previous Topic: SQL query to retrieve records in frequency of Days
Next Topic: ORA-01410 Invalid Rowid while selecting/refreshing Materialized Views
Goto Forum:
  


Current Time: Sat Dec 20 23:12:07 CST 2014

Total time taken to generate the page: 0.07171 seconds