Chirag, When you see an ORA-3113 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 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Chirag DBA Sent: Friday, October 15, 2004 11:43 AM 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=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@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 =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: end-of-file on communication channel -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l