RE: ORA-03113: end-of-file on communication channel
- From: "Charu Joshi" <joshic@xxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 15 Oct 2004 21:26:27 +0530
Chirag,
Try
SELECT * FROM dual@icaeurp1;
If this gives you the ORA-3113 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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Chirag DBA
Sent: Friday, October 15, 2004 9:13 PM
To: oracle-l@xxxxxxxxxxxxx; askdba@xxxxxxxxxxxxx
Subject: 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 ?
- 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
*********************************************************
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
