Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Lexer in 9i is more strict than in 8.0.x
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