[askdba] Re: ORA-03113: end-of-file on communication channel
- From: Nisar Tareen <ntareen@xxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 16 Oct 2004 11:32:22 -0700 (PDT)
Chiku,
After a very long time seen this error, It is related to Network / Lsnrctl, it
could be a tempory one or there is problem in communicatio to the database.
Think outside the box, let the procedure as it is and check the command one by
one or fix network error.
Good Luck.
Nisar Tareen
Chirag DBA <ChiragDBA@xxxxxxxxx> wrote:
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
---------------------------------
Do you Yahoo!?
vote.yahoo.com - Register online to vote today!
Other related posts:
