Has anybody faced a problem in oracle adapter where in
a query with “where” clause with “and” statement and two variables is not processed. The OCI library that adapter uses just hangs out and it does not perform query.
We are facing this problem with oracle 4.11 enterprise intelligent adapter on Solaris platform with oracle 8.1.6 database.
Could it be a problem of database setting? We are unable to trace out where the problem is. All other queries run, except for where clause with and and two variables.
Thansk for any kind of suggestions in advance