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 -> ORA-02287 sequence number not allowed here

ORA-02287 sequence number not allowed here

From: FaheemRao <faheemrao_at_yahoo.com>
Date: 12 Mar 2004 12:54:33 -0800
Message-ID: <43b58913.0403121254.227d0e9e@posting.google.com> 





Hi all,



select A from (select test_seq_1.nextval  a from dual )



This is simple SQL which I can run successly on my production server
(8.0.4).



Same query does not run on  test server 9.2.0.0 and I get
ORA-02287 sequence number not allowed here



Is this syntex oracle does not support anymore, becasue this SQL  does
not run on 8.1.0 as well



Is there anythign to do compatibilty parameter??




Any help would be appreciated.




Regards



Faheem Rao
Received on Fri Mar 12 2004 - 14:54:33 CST












Original text of this message













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