Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sql select sum stored procedure

sql select sum stored procedure

From: Ken Chesak <datavector_at_hotmail.com>
Date: 10 Feb 2003 14:32:24 -0800
Message-ID: <3f2f39c4.0302101432.1694076b@posting.google.com>


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) 

>= discrepancy2;
Received on Mon Feb 10 2003 - 16:32:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US