Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Weird SQL error in 8.1.6
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>...Received on Sun Feb 04 2001 - 07:35:33 CST
>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
>
>