[askdba] Re: ORA-03113: end-of-file on communication channel

  • From: Nisar Tareen <ntareen@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 16 Oct 2004 11:32:22 -0700 (PDT)

After a very long time seen this error, It is related to Network / Lsnrctl,  it 
could be a tempory one or there is problem in communicatio to the database. 
Think outside the box,  let the procedure as it is and check the command one by 
one or fix network error. 
Good Luck. 
Nisar Tareen 

Chirag DBA <ChiragDBA@xxxxxxxxx> wrote:
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

-- 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@icaeurp1 a
, psopralias@icaeurp1 b
, ps_rd_person_name@icaeurp1 c
, ps_location_tbl@icaeurp1 d
, ps_dept_tbl@icaeurp1 e
, ps_rb_worker@icaeurp1 f
, ps_rf_grp_member@icaeurp1 g
, ps_rf_provider_grp@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);
CREATE OR REPLACE procedure populateiCareUsers
ERROR at line 1:
ORA-03113: end-of-file on communication channel

Do you Yahoo!?
vote.yahoo.com - Register online to vote today!

Other related posts: