Re: Possible Use of a Cursor

From: Paul Izzo <paul.izzo_at_mosca-ag.com>
Date: 23 Feb 2005 00:23:27 -0800
Message-ID: <1109147007.008568.278270@o13g2000cwo.googlegroups.com>

Casey,

I tried your suggestion and it looks like it should work. However I get the error message ORA-00933 command not properly ended. The cursor highlights the beginning of the 2nd SELECT statement. The error message has something to do with using the ORDER BY function. I took out the ORDER BY (which defeats the purpose of using the FIRST_VALUE function) and get the same problem.

Here's a copy of what I have written:

  select papp.INSTRUCTION_NR,papp.MACHINE_PROC,papp.POSITIONS_NR   from w100.papp
  (select first_value(papp.MACHINE_PROC)   over (partition by papp.INSTRUCTION_NR order by papp.POSITIONS_NR)   first_MACHINE_PROC from tab)
  where papp.MACHINE_PROC in (3600,3400,3430) Received on Wed Feb 23 2005 - 02:23:27 CST