Print Thread
Page 2 of 2 1 2
Re: Access Violations with Oracle 10g.
#9340 08/27/07 01:30 PM
Joined: Jun 2005
Posts: 37
Norway
A
Member
Offline
Member
A
Joined: Jun 2005
Posts: 37
Norway
We have the problem at one customer site with Oracle 10.2.0.1 but another customer with 10.2.0.3 does not have to problem.

Any one know if there is an oracle bug id for this? Or is this a configuration issue?

Re: Access Violations with Oracle 10g.
#9341 10/08/07 03:18 PM
Joined: Apr 2003
Posts: 84
Parma, Italy
N
Member
Offline
Member
N
Joined: Apr 2003
Posts: 84
Parma, Italy
Hello,

We are experiencing the same problem but we have
DOA 4.06 and there isn't here Oracle.NoQueryOptimize property. Is there anything equivalent ?
Thanks bye
Nicola

Re: Access Violations with Oracle 10g.
#9342 10/08/07 08:07 PM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
You can set Optimize to False for all TOracleQuery and TOracleDataSet instances. Or upgrade to 4.0.7 and use Oracle.NoQueryOptimize.


Marco Kalter
Allround Automations
Re: Access Violations with Oracle 10g.
#9343 10/08/07 08:16 PM
Joined: Apr 2003
Posts: 84
Parma, Italy
N
Member
Offline
Member
N
Joined: Apr 2003
Posts: 84
Parma, Italy
I am going to try the second option.
Thanks bye
Nicola

Re: Access Violations with Oracle 10g.
#9344 10/10/07 12:13 PM
Joined: Jun 2005
Posts: 37
Norway
A
Member
Offline
Member
A
Joined: Jun 2005
Posts: 37
Norway
We solved this particular problem on the Oracle side.

We had the problem when we used Oracle Client 9.2.0.6 - upgrading to either 9.2.0.8 or 10 on the client side fixed the problem.

Page 2 of 2 1 2

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.049s Queries: 13 (0.023s) Memory: 2.5315 MB (Peak: 3.0379 MB) Data Comp: Off Server Time: 2024-05-03 14:23:59 UTC
Valid HTML 5 and Valid CSS