Re: Sequences in 8.1.7 vs 9i

I have never seen () after nextval in 7.3 or 8i or 9i .

-Bp
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, January 22, 2003 1:48 PM

> Hello everyone.
>
> This one stumps me and I'm wondering if it is a bug that was resolved in
> 9i. Here is sample code.
>
> Create sequence a;
> Create table xxx(numtest number, testvalue varchar2(100));
>
> Inside PL/SQL block and from SQL*Plus Prompt;
>
> Insert into xxx(numbest, testvalue) values (a.nextval(), 'TEST');
>
> PL/SQL: ORA-02287: sequence number not allowed here
>
> Take out the () after the sequence name and all is well. Anyone
experience
> something like this???
> Application (not my code) written in 8i but imported the database into 9i.
>
>
>
> Thank You
>
> Stephen P. Karniotis
> Product Architect
> Compuware Corporation
> Direct: (248) 865-4350
> Mobile: (248) 408-2918
> Email: Stephen.Karniotis_at_Compuware.com
> Web: www.compuware.com
>
>
>
>
> The contents of this e-mail are intended for the named addressee only. It
> contains information that may be confidential. Unless you are the named
> addressee or an authorized designee, you may not copy or use it, or
disclose
> it to anyone else. If you received it in error please notify us
immediately
> and then destroy it.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Karniotis, Stephen
> INET: Stephen_Karniotis_at_compuware.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: BigP
  INET: big_planet_2000_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).