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: <3C512901.35022228@crpa.it>

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)

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