migration to oracle client 9.2.0.5 or 10.... : AV in oracle client

[pult]

On the client 8.1 appendix works normally. At updating the client on version 9 or 10 there is a failure by a call of method Refresh. Replacement on Open/Close has not helped. The situation was corrected with property Optimize: = False;

Probably in the client oracle there is a mistake. The opportunity of global switching-off Optimize for TOracleSession is necessary.

It is similar to the following:

OracleSession1.OptimizePrepare := False;

(default value is True).

 

[Marco Kalter]

I have not received any problem report about this before. Can you send me a demo project to reproduce this?

 

[pult]

I think it is same problem as in post:
Problem with ORA-24909 error on Oracle 10G
http://www.allroundautomations.com/ubb/ultimatebb.php?ubb=get_topic;f=1;t=002352

The difficult application... The data base structure is big ...
The problem is absent at return to ORACLE SERVER 9.

 

[Marco Kalter]

This is an Oracle Server 10.2 bug. Are you using this version?

Note that in 4.0.7 there is a global Oracle.NoQueryOptimize variable that you can set to True to work around the problem.

 

[pult]

10.2
Thanks !