Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> sql select sum stored procedure
Oracle 8.1.7
This SQL works fine in SQLPlus but does not work in a stored
procedure.
In a stored procedure it does not like the (SELECT SUM( .
select rh.case_no into v_ct
FROM w_wage_employer rwe, w_rg101 rh, w_wage_case rwc
WHERE rwe.cd_disposition = 'NONE' AND rh.cd_case_category IN ('06','08','09') AND rh.case_status = '2' AND rwc.id_rg101 = rh.id_rg101 AND rwc.id_wage = rwe.id_wage AND rwe.amt_wages - ( SELECT SUM(gwsc.amt_payment) FROM w_gws_client gwsc WHERE gwsc.cd_source = rwe.cd_source AND gwsc.case_no = rwe.case_no AND gwsc.dt_run = rwe.dt_run AND gwsc.log_no = rwe.log_no AND gwsc.cd_income = '1' AND gwsc.is_income = 'I' AND gwsc.dt_claim >= rwc.dt_month_1 AND gwsc.dt_claim <= rwc.dt_month_3 AND gwsc.client_no = rwe.client_no)