ORA-03113: end-of-file on communication channel 2004-10-15 - By Charu Joshi
Chirag,
Try
SELECT * FROM dual@(protected);
If this gives you the ORA-3113 (See ORA-3113.ora-code.com) 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@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of Chirag DBA
Sent: Friday, October 15, 2004 9:13 PM
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
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@(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 = 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 (See ORA-03113.ora-code.com): 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
|
|
