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 [EMAIL PROTECTED] ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > 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:[EMAIL PROTECTED]] > > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
