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

From: Charu Joshi <joshic_at_mahindrabt.com>
Date: Fri, 15 Oct 2004 21:26:27 +0530
Message-ID: <MHEAIPLKCACENJKNJIALCEAOCIAA.joshic@mahindrabt.com>

Chirag,

Try

SELECT * FROM dual_at_icaeurp1;

If this gives you the ORA-3113 error (I think it should), then your remote database is not available. You would need it up, before you can compile the procedure.

Regards,
Charu.

-----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 9:13 PM
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 execute immediate 'truncate table temp_profile_users';

insert into temp_profile_users
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 = b.oprid

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

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

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


*********************************************************
Disclaimer:          

This message (including any attachments) contains 
confidential information intended for a specific 
individual and purpose, and is protected by law. 
If you are not the intended recipient, you should 
delete this message and are hereby notified that 
any disclosure, copying, or distribution of this
message, or the taking of any action based on it, 
is strictly prohibited.

*********************************************************
Visit us at http://www.mahindrabt.com

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

Received on Fri Oct 15 2004 - 10:52:39 CDT