Re: ORACLE BUG FROM 8.1.6 ON! HELP!

From: Kirmo Uusitalo <kirmo.uusitalo.no.spam_at_iki.fi>
Date: Sun, 29 Sep 2002 15:24:50 +0300
Message-ID: <9nrdpuk3bg3428oc8fg46jb92mt4imt5ug@4ax.com>

On Sat, 28 Sep 2002 10:39:37 GMT, "P.C" <webmaster_at_killingfloor.it> wrote:

>Hi, everybody:

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

Try this:
select id_cen.nextval id_cen from dual union select id_cen from centro;

Havent tested it though...

HTH, Kirmo Uusitalo

>
Received on Sun Sep 29 2002 - 07:24:50 CDT