Oracle 9I to 10G conversion.

[kev1_mc]

Has anyone experienced any issues with converting from 9I to 10g?
I am having the following issue with OR and AND statements in SQL queries.

9i
F and Exception Exception
F or Exception F
Exception And F F
Exception or F Exception

10g
F and Exception Exception
F or Exception Exception
Exception And F F
Exception or F F

Is there a patch out there that fixes? I have alot of queries written to match 9i and a conversion to 10g will cause alot of issues.

[owen]

slightly confused but what is Exception?

[kev1_mc]

exception is null. it seems that oracle 10g handles null values in AND/OR conditions in a different way that it handles it in Oracle 9i. The order in which null values are placed in a condition sometimes give a different result depending on the order it is written in, and the type of condition it is written in.

[owen]

wow look like you have a problem. read up on a all the 9 to 10 conversion articles that you can find maybe there is a patch that will allow you to maintain your current queries. sometimes blogsearch.google.com is better.

[kev1_mc]

i have been doing research all over. nothing yet. i think that my error has to do with configuration of the different environments.