OraFAQ Forum: SQL & PL/SQL » ORA-03113 end-of-file on communication channel

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-03113 end-of-file on communication channel (oracle 10 g)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

ORA-03113 end-of-file on communication channel [message #572837]

Tue, 18 December 2012 01:32

hemant_khandare
Messages: 65
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 30 times)

Report message to a moderator

Re: ORA-03113 end-of-file on communication channel [message #572839 is a reply to message #572837]

Tue, 18 December 2012 01:49

Michel Cadot
Messages: 54192
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

Report message to a moderator

Re: ORA-03113 end-of-file on communication channel [message #572876 is a reply to message #572839]

Tue, 18 December 2012 06:25

cookiemonster
Messages: 9152
Registered: September 2008
Location: Rainy Manchester

Senior Member

And remove this from your code:

exception 
  when others then
      null;

read WHEN OTHERS

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 22 09:33:35 CDT 2013

Total time taken to generate the page: 0.12068 seconds