Re: ORA-02287 sequence number not allowed here

FaheemRao wrote:

> 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

No parameter required ... just writing better code.

select test_seq_1.nextval from dual;

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)