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!