pal wrote:
> 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..
Remove all but one column from the SELECT and if it works add your
columns back in one or two at a time until it breaks.
In what version (to 3 decimal places minimum)?
What operating system?
If *NIX have you verified kernel settings against Oracle's install docs?
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Nov 22 2007 - 12:27:56 CST
