Re: ORACLE BUG FROM 8.1.6 ON! HELP!

"P.C" wrote:
>
> 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?

What is the error? I'm guessing it has something to do with mismatched datatypes?? a sequence is NUMBER(9) while the table column was NUMBER(4). It does seem strange to get an error on the newer version. Maybe it is a naming error.

Have you tried:

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

??

-- 
Edward J. Prochak   --- Magic Interface, Ltd.
Ofc: 440-498-3700   --- 7295 Popham Place, Solon, OH 44139
on the web at       --- http://www.magicinterface.com
email: ed.prochak_at_magicinterface.com