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

damorgan wrote:
>
> 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

Similarly,

package
  proc A(p number);

package A
  proc A(p number default ... )

will no longer compile in 9i as it did in earlier versions. Funnily enough the bizarre practice of doing this in the first place seems to be most prevalent in Oracle Portal !

Connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."