ORA-03113: end-of-file on communication channel 2004-10-15 - By Bobak, Mark
Chirag,
When you see an ORA-3113 (See ORA-3113.ora-code.com) 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 (See ORA-3113.ora-code.com) 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@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of Chirag DBA
Sent: Friday, October 15, 2004 11:43 AM
To: oracle-l@(protected); askdba@(protected)
Subject: ORA-03113 (See ORA-03113.ora-code.com): end-of-file on communication channel
Hi ,
I m getting error ' ORA-03113 (See ORA-03113.ora-code.com): 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@(protected) a
, psopralias@(protected) b
, ps_rd_person_name@(protected) c
, ps_location_tbl@(protected) d
, ps_dept_tbl@(protected) e
, ps_rb_worker@(protected) f
, ps_rf_grp_member@(protected) g
, ps_rf_provider_grp@(protected) 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 (See ORA-03113.ora-code.com): end-of-file on communication channel
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
|
|
