Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00911: invalid character
My compatability is set to 9.2.0.0.0.
My v$version is
BANNER
Must I set compatability to 9.2.0.1.0 from 9.2.0.0.0?
The description of 'compatability was "Allows use of new release, while at the same time guaranteeing backward compatibility with earlier release." I thought this meant that all current release features could be used and that backward compatibility was set by what compatability was set to. I this incorrect?
Sybrand Bakker wrote:
> On Sun, 13 Apr 2003 13:00:57 GMT, sdg <nospan_at_noway.org> wrote:
>
> >Dave,
> >Tried without success.
> >
> >SQL> l
> > 1 SELECT cust_last_name,
> > 2 case credit_limit when 100 then `low`
> > 3 when 5000 then `high`
> > 4 else `Medium` AS casecr
> > 5* from customers
> >SQL> /
> > case credit_limit when 100 then `low`
> > *
> >ERROR at line 2:
> >ORA-00911: invalid character
> >
> >
> >SQL>
>
> case is a 9i thingy. Please check the compatibility parameter of your
> database.
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Sun Apr 13 2003 - 08:52:10 CDT