Re: Weird SQL error in 8.1.6

From: John Jones <john.jones_at_duke.edu>
Date: Mon, 5 Feb 2001 08:47:38 -0500
Message-ID: <95maqq$d3v$1@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 - 07:47:38 CST