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).