Turning caspol -s off and Oracle ODP stops to retrieve data.
One of my clients, which got close network, use caspol -s off to turn down client side stations security. After w while ODP code that run perfectly on developers machine stop to work, while MS oracle driver works perfectly. ODP code throws exceptions such as “Invalid Operation” or others that really didn’t tell you anything. As you probably figure out it took us a lot of time to find that turning off caspol causes ODP to misbehave, but we humans, don’t we?
Now the ball is in the hands of Oracle guys …. I’ll keep you posted.