Found the problem. We have an init.ora parameter "cursor_sharing = force"
set. this causes the parser to act differently. We really need this option
because PeopleSoft and our developers are not taking use of Bind variables.
--
John Jones
Senior Oracle DBA
Duke University, OIT
john.jones_at_duke.edu
John Jones <john.jones_at_duke.edu> wrote in message
news:95maqq$d3v$1_at_news.duke.edu...
> I get the following error
>
> ERROR at line 1:
> ORA-00933: SQL command not properly ended
>
> When I put the space back, it works.
>
>
> --
> John Jones
> Senior Oracle DBA
> Duke University, OIT
> john.jones_at_duke.edu
> Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote in message
> news:981293523.16254.0.nnrp-13.9e984b29_at_news.demon.co.uk...
> >
> > In what way will it 'not run'.
> >
> > Have you executed this from an SQL*Plus session
> > and found that
> > a) Returns to the prompt, without showing 'No rows returned'
> > b) Produces an Oracle error - if so which one
> > c) Other
> >
> >
> > --
> > Jonathan Lewis
> > Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
> >
> > Practical Oracle 8i: Building Efficient Databases
> > Publishers: Addison-Wesley
> >
> > Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
> >
> >
> >
> > John Jones wrote in message <95fc8b$io7$1_at_news.duke.edu>...
> > >We are in the middle of testing of upgrading from Oracle 8.0.5.1 to
8.1.6.2
> > >My technical team has come up with an interesting error that Oracle
Support
> > >seems unable to reproduce or answer. We have a vendor package that
> > >generates SQL code and then submits it. Below is an example of the
code
we
> > >are having problems with. The code will run in 8.0.5.1 but not in
8.1.6.1
> > >We are running AIX 4.3.3
> > >
> > >select sysdate from dual where '1' = '1'and '2' ='2'
> > >/
> > >
> > >**** notice that there is no space between '1'and **********
> > >
> > >Anybody ever see this behaviour or can you recreate on your system.
> > >
> > >--
> > >John Jones
> > >Senior Oracle DBA
> > >Duke University, OIT
> > >john.jones_at_duke.edu
> > >419-5737
> > >
> > >
> >
> >
>
>
Received on Mon Feb 05 2001 - 08:38:01 CST
