Home » RDBMS Server » Server Administration » Problem in procedure ORA-03113: end-of-file on communication channel
Problem in procedure ORA-03113: end-of-file on communication channel [message #271403] Mon, 01 October 2007 10:03 Go to next message
ramabhupalrr
Messages: 69
Registered: July 2005
Location: India
Member

Hi All,
i am working on oracle 9.2.0.1.0 version.

i am trying to write a procedure using bulk collect i am getting the end-of-file on communication channel. 


i tried like this 

SQL> CREATE OR REPLACE procedure insert_test
  2  as
  3
  4
  5   type p_type is table of emp%rowtype ;
  6   p_row p_type;
  7
  8  BEGIN
  9
 10     select * bulk collect into p_row from emp ;
 11
 12  END;
 13  /
SQL> exec insert_test;
SQL>


it is working fine for me 

but i am trying since two days but i am unable to trace why the problem.


SQL> desc test;
 Name
                                               Null?    Type
 -----------------------------------------------------------------------------------------------------------------------
------------------------------------------------------ -------- --------------------------------------------------------
------------------------------------------------------------
 P_ID
                                               NOT NULL VARCHAR2(15)
 SEQ_NO
                                               NOT NULL NUMBER
 ITEM_NAME
                                                        VARCHAR2(2000)
 DESCRIPTION
                                                        VARCHAR2(4000)
 SCHEDULE
                                                        DATE
 ITEM_TYPE
                                               NOT NULL VARCHAR2(8)
 COMPLETION_DATE
                                                        DATE
 NA
                                                        NUMBER

SQL>
SQL> select * from test;

Execution Plan
----------------------------------------------------------
   0      SELECT STATEMENT Optimizer=CHOOSE
   1    0   TABLE ACCESS (FULL) OF 'TEST'




Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
          0  consistent gets
          0  physical reads
          0  redo size
          0  bytes sent via SQL*Net to client
          0  bytes received via SQL*Net from client
          0  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
      83888  rows processed

SQL> CREATE OR REPLACE procedure insert_test
  2  as
  3
  4
  5   type p_type is table of test%rowtype ;
  6   p_row p_type;
  7
  8  BEGIN
  9
 10     select * bulk collect into p_row from test ;
 11
 12  END;
 13  /
SQL> exec insert_test;
BEGIN insert_test; END;

*
ERROR at line 1:
ORA-03113: end-of-file on communication channel


Is it depends on the size of the table? 
i am thankful for your suggestions.

Thanks,
Rama Bhupal

Re: Problem in procedure ORA-03113: end-of-file on communication channel [message #271404 is a reply to message #271403] Mon, 01 October 2007 10:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-03113 = Oracle bug (most of the time) => search on Metalink and/or call Oracle support

By the way, with 9.2.0.1 you will get no help from Oracle unless you upgrade to 9.2.0.8.

Regards
Michel

[Updated on: Mon, 01 October 2007 10:18]

Report message to a moderator

Re: Problem in procedure ORA-03113: end-of-file on communication channel [message #271427 is a reply to message #271403] Mon, 01 October 2007 11:40 Go to previous messageGo to next message
ramabhupalrr
Messages: 69
Registered: July 2005
Location: India
Member

Hi Michel,

It is working fine for emp table. But it is not work test table.
why it is not working . First i have already gone throgh the
http://ora-03113.ora-code.com/ site it is showing there could be some network problems. But I did n't understand.

Please let me know what could be the problem.

Thanks,
Rama Bhupal




Re: Problem in procedure ORA-03113: end-of-file on communication channel [message #271441 is a reply to message #271427] Mon, 01 October 2007 12:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A bug is a bug.
It happens when it wants.

Regards
Michel
Re: Problem in procedure ORA-03113: end-of-file on communication channel [message #278560 is a reply to message #271403] Mon, 05 November 2007 01:21 Go to previous messageGo to next message
halfydba
Messages: 20
Registered: November 2007
Location: Australia
Junior Member
An ora-03113 is an ora-7445 in disguise. Have a look in your alert log for an ora-07445 and upload the related trace file to Oracle.
Re: Problem in procedure ORA-03113: end-of-file on communication channel [message #278561 is a reply to message #271427] Mon, 05 November 2007 01:23 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

ramabhupalrr wrote on Mon, 01 October 2007 22:40

Hi Michel,

It is working fine for emp table. But it is not work test table.
why it is not working . First i have already gone throgh the
http://ora-03113.ora-code.com/ site it is showing there could be some network problems. But I did n't understand.

Please let me know what could be the problem.

Thanks,
Rama Bhupal






Previous Topic: ORA-00600
Next Topic: control_file_record_keep_time
Goto Forum:
  


Current Time: Thu Dec 08 20:06:07 CST 2016

Total time taken to generate the page: 0.05553 seconds