Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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 ?
CREATE OR REPLACE procedure populateiCareUsers
is
begin
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;
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 15 2004 - 10:38:49 CDT
![]() |
![]() |