Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL Cursor problem
Richard Elliott wrote:
>
>
> PLS-00103: Encountered the symbol "(" when expecting one of the
> following: <an identifier> <a double-quoted delimited-identifier>
>
> cursor summary_cursor
> is
> SELECT Prod_Date, SUM(MCF_In) mcfin, SUM(Pack_Change_MCF) packmcf,
> SUM(MCF_Out) mcfout, SUM(DT_In) dtin, SUM(Pack_Change_DT) packdt
> SUM(DT_Out) dtout
> !! FROM (
> SELECT m.Production_Date Prod_Date,
> SUM(DECODE(s.Station_Flow,'INTO SYSTEM', m.MCF_at_1473,0)) MCF_In,
> 0 Pack_Change_MCF,
> SUM(DECODE(s.Station_Flow,'OUT OF SYSTEM', m.MCF_at_1473,0)) MCF
> SUM(DECODE(s.Station_Flow,'INTO SYSTEM', m.Dekatherm,0)) DT_In
> 0 Pack_Change_DT,
> SUM(DECODE(s.Station_Flow,'OUT OF SYSTEM', m.Dekatherm,0)) DT_Ou
> ******* cliped *****
>
There seems to be a missing comma on line 2 of your query (after packdt).
Marc Received on Wed Sep 30 1998 - 01:26:51 CDT