Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ORACLE BUG FROM 8.1.6 ON! HELP!

ORACLE BUG FROM 8.1.6 ON! HELP!

From: P.C <webmaster_at_killingfloor.it>
Date: Sat, 28 Sep 2002 10:39:37 GMT
Message-ID: <JFfl9.154493$ub2.3413178@news1.tin.it>


Hi, everybody:
Try this on win with oracle 8.1.x

CREATE SEQUENCE ID_CEN
INCREMENT BY 1
MAXVALUE 9999
MINVALUE 1
;

CREATE TABLE CENTRO (

       ID_CEN               NUMBER(4) NOT NULL,
       DESCRIZIONE          VARCHAR2(30) NULL,
       PRIMARY KEY (ID_CEN)

);

select id_cen.nextval from dual union select id_cen from centro;

It works on 8.1.5 and lower and gives an error on 8.1.6 and upper? Any hints or workaround? Received on Sat Sep 28 2002 - 05:39:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US