Lexer in 9i is more strict than in 8.0.x

hi,

We run several custom written VB-applications that generate masses of dynamical SQLs to be executed on an Oracle server under NT4. Recently we upgraded from 8.0.6 to 9i, and discovered that the lexer in 9i is a bit more strict than in 8.0.6. Several of the SQLs now fail with an ORA-01722 error.

The problem seems to be that the lexer in 8.0.6 inserts missing white-space between numerical constants and keywords when necessary, e.g. (a highly constructed example, not actually used in production code) "select 1from dual" (notice the missing space between the "1" and "dual") worked ok on 8.0.6 but fails (understandably so) on 9i.

Does anyone know of a compatebility setting or some such that will make the lexer in 9i operate like in 8.0.6? We could need this as a workaround until the various development teams can go through their code and insert spaces at the proper places.

-- 
jakob