REPOST: Oracle 9i and "lenient" SQL parsing

From: Cristian Veronesi <c.veronesi_at_crpa.it>
Date: Fri, 25 Jan 2002 10:44:33 +0100
Message-ID: <5$--$%%%%--%-$-%-$@news.noc.cabal.int>

Hello.
We are trying to run a third-party Windows app written for Oracle 8i against a 9.0.1.2 database running on SuSE SLES7. This apps tries to issue a SQL statement like that (notice the missing space between "1" and "and"):

select * from tipi_latte where tip_lat_cod=1and tip_lat_des like 'A%' ;

I said to the third-party developers that this is an incorrect SQL statement but they says that against Oracle 8i it works. I don't have an Oracle 8i instance to try but I have a 7.3.4 one so I tried:

SQL> select * from tipi_latte where tip_lat_cod=1and tip_lat_des like
'A%';

TIP_LAT_COD TIP_LAT_DES

----------- --------------------------------------------------
          1 Alimentare

It works!!! And here's the result against the 9i database instead:

SQL> select * from tipi_latte where tip_lat_cod=1and tip_lat_des like
'A%';

select * from tipi_latte where tip_lat_cod=1and tip_lat_des like 'A%'

                                           *

ERROR at line 1:
ORA-01722: invalid number

Is there a way to tell Oracle 9i to be more lenient with this type of statements?

I noticed that parameter "compatible" is set to 9.0.0. I tried to set it to 8.1.0 but the database gave me a couple of errors on startup (sorry, I did not captured the error messages).

Any suggestion?

Regards, Cristian

-- 
Cristian Veronesi ><((((º> http://www.crpa.it

There are no good wars, with the following exceptions: The American 
Revolution, World War II, and the Star Wars Trilogy. (Bart Simpson)

===== WAS CANCELLED BY ====:
From: Cristian Veronesi <c.veronesi_at_crpa.it>
Control: cancel <3C512901.35022228_at_crpa.it>
Subject: cmsg cancel <3C512901.35022228_at_crpa.it>
Date: Mon, 28 Jan 2002 00:51:40 GMT
Message-ID: <cancel.3C512901.35022228_at_crpa.it>
X-No-Archive: yes
Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server
NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88
Lines: 1         
Path: news.uni-stuttgart.de!news.fh-hannover.de!feed.news.nacamar.de!news.maxwell.syr.edu!newsfeed.frii.com!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller
Xref: news.uni-stuttgart.de control:40723566

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers.

Received on Fri Jan 25 2002 - 03:44:33 CST