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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Possible Use of a Cursor

Re: Possible Use of a Cursor

From: Paul Izzo <paul.izzo_at_mosca-ag.com>
Date: 23 Feb 2005 00:31:49 -0800
Message-ID: <1109147509.605843.285720@g14g2000cwa.googlegroups.com>


  I changed the SELECT statement to add a "," after "from w100.papp"

  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)

  But now I get an new error message ORA-00439 saying, "feature not enabled: OLAP Window Functions" Is this a show stopper? Received on Wed Feb 23 2005 - 02:31:49 CST

Original text of this message

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