ORA-03113: end-of-file on communication channel
- From: Chirag DBA <ChiragDBA@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>, askdba@xxxxxxxxxxxxx
- Date: Fri, 15 Oct 2004 21:12:31 +0530
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@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);
end;
--------------------------------------------------------------------------------------------
ERRORS I M GETTING
--------------------------------------------------------------------------------------------
CREATE OR REPLACE procedure populateiCareUsers
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
--
//www.freelists.org/webpage/oracle-l
Other related posts:
