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

Home -> Community -> Usenet -> c.d.o.server -> Re: Lexer in 9i is more strict than in 8.0.x

Re: Lexer in 9i is more strict than in 8.0.x

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Thu, 21 Feb 2002 18:14:58 GMT
Message-ID: <3C753936.22016FA0@ci.seattle.wa.us>


Or ... look in the init.ora for CURSOR_SHARING=FORCE

If there take it out.

But better yet ... let things break and fix the poorly written SQL. I would also start code reviews so that other developers have an opportunity to review all code and offer suggestions.

And, if found, remove it.

Daniel Morgan

Sybrand Bakker wrote:

> jak_at_spamcatcher.observer.no (Jakob A. Rivertz) wrote in message news:<3c74d2a6.3641707562_at_news1.enitel.no>...
> > I wrote:
> > >"select 1from dual" (notice the missing space between the "1"
> > >and "dual")
> >
> > Should read: notice the missing space between the "1" and _"From"_, of
> > course.
> >
> > The original question still stands. Has anyone else seen this? Is
> > there a temporary fix?
> >
> > Thx.
>
> compatible = 8.0.6 in init<SID>.ora ?
>
> Hth
>
> Sybrand Bakker
> Senior Oracle DBA
Received on Thu Feb 21 2002 - 12:14:58 CST

Original text of this message

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