RE: ORA-03113: end-of-file on communication channel

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Fri, 15 Oct 2004 11:49:19 -0400
Message-ID: <AA29A27627F842409E1D18FB19CDCF275A9B16@AABO-EXCHANGE02.bos.il.pqe>

Chirag,

When you see an ORA-3113 error, it's always important to check your dump directory for a trace file. Often, there will be one with more details on the error that occurred. ORA-3113 is basically just the Oracle client telling you "I lost my=20 connection to the database unexpectedly". The dump directory may help more info available.

-Mark

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Chirag DBA Sent: Friday, October 15, 2004 11:43 AM
To: oracle-l_at_freelists.org; askdba_at_freelists.org Subject: ORA-03113: end-of-file on communication channel

Hi ,

I m getting error ' ORA-03113: end-of-file on communication channel ' while creating a procedure which uses database link to populate data.

Can anyone tell me what can be the problem ?

Chirag Majmundar

CREATE OR REPLACE procedure populateiCareUsers is
begin

execute immediate 'drop database link icaeurp1';
create database link icaeurp1
connect to act_parts identified by act_parts
using=20 execute immediate 'truncate table temp_profile_users';

insert into temp_profile_users=20
select a.oprid
, c.last_name
, c.first_name
, e.descr department
, d.descr location
, h.name1 provider_grp_name

from psoprdefn_at_icaeurp1 a
, psopralias_at_icaeurp1 b
, ps_rd_person_name_at_icaeurp1 c
, ps_location_tbl_at_icaeurp1 d
, ps_dept_tbl_at_icaeurp1 e
, ps_rb_worker_at_icaeurp1 f
, ps_rf_grp_member_at_icaeurp1 g
, ps_rf_provider_grp_at_icaeurp1 h

where a.oprid =3D b.oprid

and b.person_id =3D c.person_id
and f.person_id =3D b.person_id
and f.location=3D d.location
and f.deptid =3D e.deptid
and g.person_id =3D b.person_id
and g.provider_grp_id =3D h.provider_grp_id;

insert into profile_users select * from temp_profile_users where oprid not in(select oprid from profile_users); end;=20

-------------------------------------------------------------------------=
-------------------

ERRORS I M GETTING

-------------------------------------------------------------------------=
-------------------

CREATE OR REPLACE procedure populateiCareUsers *
ERROR at line 1:
ORA-03113: end-of-file on communication channel

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 15 2004 - 10:45:02 CDT