Re: Sequences in 8.1.7 vs 9i

Steven,

m.b. this is dumb question, but did you check, that there is no function called "nextval" inside user-written package called "a", which hides actual retrieval of sequence next value?

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, January 23, 2003 8:49 AM

> Yes. I agree that works. The problem is that there are over 2000 lines
of
> code similar to the one I identified. I'm not interested in recommending
> changing all of it unless it's a conversion issue.
>
> Thanks for the help.
>
> 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
>
> -----Original Message-----
> Sent: Thursday, January 23, 2003 2:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Sequences in 8.1.7 vs 9i
>
> Stephen,
>
> What about this,
> SQL > Create sequence a;
> SQL > Create table xxx(numtest number, testvalue varchar2(100));
> SQL > declare
> x number:=0;
> begin
> select a.nextval into x from dual;
> Insert into xxx values(x, 'TEST');
> end;
>
> Rgrd,
>
> Sony
>
> > -----Original Message-----
> > From: Karniotis, Stephen [SMTP:Stephen_Karniotis_at_compuware.com]
> > Sent: Thursday, January 23, 2003 4:49 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Sequences in 8.1.7 vs 9i
> >
> > 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: Sony kristanto
> INET: Sony_at_polyfincanggih.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).
>
>
>
> 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: Igor Neyman
  INET: ineyman_at_perceptron.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).