Ok, here is one more update on this problem: If I remove all UPPER() from the query and have the proper case values, I get the correct result form both SQL Plus and OCI calls.
Is there a know issue with UPPER function for indexes in versions 10.1 or 10.2?
Thanks a lot, mj




Reply With Quote