ORA-03113: end-of-file on communication channel

  SELECT settlements.emp_code,
         settlements.leave_days,
         settlements.leave_amount,
         settlements.gratuity_days,
         settlements.gratuity_amount,
         settlements.other_earnings,
         settlements.pending_days,
         settlements.pending_amount,
         settlements.loan_bal_amount,
         settlements.other_deductions,
         settlements.other_earnings_1,
         settlements.other_earnings_acno_1,
         settlements.other_earnings_2,
         settlements.other_earnings_acno_2,
         settlements.other_deductions_1,
         settlements.other_deductions_acno_1,
         settlements.other_deductions_2,
         settlements.other_deductions_acno_2,
         settlements.termination_date,
         desg_master.desg_cd,
         desg_master.desg_name,
         dept_master.dept_cd,
         dept_master.dept_name,
         emp_master.l_name,
         emp_master.m_name,
         emp_master.f_name,
         emp_master.join_date,
         emp_master.left_date,
         emp_master.left_reason,
         emp_master.basic,
         emp_master.prm_addr_1,
         emp_master.prm_addr_2,
         emp_master.prm_addr_3,
         emp_master.bank_acno,
         paywork.ot1_hrs,
         paywork.ot1_amount,
         paywork.ot2_hrs,
         paywork.ot2_amount,
         paywork.otfxdrt1_hours,
         paywork.otfxdrt1_amount,
         paywork.otfxdrt2_hours,
         paywork.otfxdrt2_amount,
         paywork.overpay_deduction,
   		paywork.present_days,
			paywork.sick_leave_days_full,
			paywork.sick_leave_days_half,
			paywork.mat_leave_days,
			paywork.injury_days,
			paywork.norm_ph_days_availed,
			paywork.norm_wo_days_availed,
  			paywork.fxdern1,
			paywork.fxdern2,
			paywork.fxdern3,
			paywork.fxdern4,
			paywork.fxdern5,
			paywork.fxdern6,
			paywork.fxdern7,
			paywork.fxdern8,
			paywork.varern1,
			paywork.varern2,
			paywork.varern3,
			paywork.varern4,
			paywork.varern5,
			paywork.varern6,
			paywork.varern7,
			paywork.varern8,
			paywork.hallow,
			paywork.callow,
         paywork.roundoff_deduction,
			paywork.ot1_hrs,
			paywork.ot1_amount,
			paywork.ot2_hrs,
			paywork.ot2_amount,
			paywork.otfxdrt1_hours,
 			paywork.otfxdrt1_amount,
			paywork.otfxdrt2_hours,
			paywork.otfxdrt2_amount,
			paywork.net_basic,
			paywork.sick_leave_basic_full,
			paywork.sick_leave_basic_half,
			paywork.mat_leave_basic,
			paywork.injury_basic,
			paywork.ph_basic,
			paywork.wo_basic,
			paywork.lieu_basic,
			paywork.norm_ph_basic,
			paywork.norm_wo_basic,
			paywork.paid_leave_basic,
			paywork.varded9,
			paywork.varded10,
			paywork.varded11,
			paywork.varded12,
			paywork.varded13,
			paywork.varded14,
			paywork.varded15,
			paywork.varded16,
         '',
         '',
        0.00 as dfd1,
        0.00 as dfd2,
        0.00 as dfd3,
         0.00 as dfd4,
         0.00 as dfd5,
         0.00 as dfd6,
         0.00 as dfd8,
         0.00 as dfd7,
         0.00 as dvd1,
         0.00 as dvd2,
         0.00 as dvd3,
         0.00 as dvd4,
         0.00 as dvd5,
         0.00 as dvd6,
         0.00 as dvd7,
         0.00 as dvd8,


         '' as vd4,

         '' as vd6,

         '' as vd7,

         '' as vd8,

         '' as fd8,

         '' as fd7,

         '' as fd6,

         '' as fd5,

         '' as fd4,

         '' as fd3,

         '' as fd2,

         '' as fd1,

         '' as vd1,

         '' as vd2,

         '' as vd4,

         '' as vd5,

         '' as vd3,

         location.location_name,
			location.curr_dec,
			location.curr_unit,
			paywork.fxdern9,
			paywork.fxdern10,
			paywork.fxdern11,
			paywork.fxdern12,
			paywork.fxdern13,
			paywork.fxdern14,
			paywork.fxdern15,
			paywork.fxdern16,
			paywork.varern9,
			paywork.varern10,
			paywork.varern11,
			paywork.varern12,
			paywork.varern13,
			paywork.varern14,
			paywork.varern15,
			paywork.varern16,
			0.00 as dfd9,
			0.00 as dfd10,
			0.00 as dfd11,
			0.00 as dfd12,
			0.00 as dfd13,
			0.00 as dfd14,
			0.00 as dfd15,
			0.00 as dfd16,
			'' as fd9,
			'' as fd10,
			'' as fd11,
			'' as fd12,
			'' as fd13,
			'' as fd14,
			'' as fd15,
			'' as fd16,
			0.00 as dvd9,
			0.00 as dvd10,
			0.00 as dvd11,
			0.00 as dvd12,
			0.00 as dvd13,
			0.00 as dvd14,
			0.00 as dvd15,
			0.00 as dvd16,
			'' as vd9,
			'' as vd10,
			'' as vd11,
			'' as vd12,
			'' as vd13,
			'' as vd14,
			'' as vd15,
			'' as vd16
    FROM dept_master,
         desg_master,
         emp_master,
         paywork,
         settlements,
         location,
         user_location
   WHERE ( emp_master.desg_cd = desg_master.desg_cd ) and
         ( emp_master.loc_cd = dept_master.loc_cd ) and
         ( emp_master.dept_cd = dept_master.dept_cd ) and
         ( emp_master.loc_cd = location.loc_cd ) and
         ( dept_master.loc_cd = location.loc_cd ) and
         ( paywork.emp_code = emp_master.emp_code ) and
         ( settlements.emp_code = emp_master.emp_code ) and
         ( emp_master.dept_cd = user_location.dept_cd ) and
         ( emp_master.loc_cd = user_location.loc_cd ) and
         ( dept_master.dept_cd = user_location.dept_cd ) and
         ( dept_master.loc_cd = user_location.loc_cd ) and
         ( location.loc_cd = user_location.loc_cd ) and
         ( settlements.emp_code like :RA_Emp_Code ) AND
         ( user_location.login_name = :RA_loginname );

if i run this query i'm getting "ORA-03113: end-of-file on communication channel" this error..

I tried many things and i noticed one thing if i remove "( settlements.emp_code like :RA_Emp_Code ) AND " this from the where clause it is working properly...but i cant remove the argument from my application.

can anyone tell me what is the reason for the error.. Received on Thu Nov 22 2007 - 05:50:36 CST