PL/SQL Developer crashes

[nico]

Hi,

I have a problem using the PL/SQL Developer with the following configuration:

database client: OCI 9.2.0
OS: Windows 2003 Server SP1 (access via terminal server)

db server: 10.2
OS: Windows 2003 Server SP1

The PL/SQL Developer 6.0.5 (and our application using DOA 4.0.6.2 too) crashes after simpel queries.

Is there a known problem with these configuration?

 

[Marco Kalter]

For PL/SQL Developer you will need to upgrade to 6.0.6 for 10.2 compatibility.

What exactly is the nature of the crash in your Direct Oracle Access application?

 

[nico]

There are two kinds of crashes. The first one is that the PL/SQL Developer (and also our application) is closed without any message. And the other is a error message "Access violation at address 00000000. Read of address 00000000".

btw. sorry for choosing the wrong forum.

 

[Marco Kalter]

The forum is partially right. For your Direct Oracle Access application you probably need to set Optimize to False for all TOracleQuery and TOracleDataSet instances. You can also set the global Oracle.NoQueryOptimize boolean to False.

 

[nico]

Please could you explain, why it is necessary to disable the optimization flag?

 

[egiron]

I am having the same problem with exactly the same configuration, have you find a simpler way to fix it? Upgrading to the 10g instant client solves the problem?

 

[Marco Kalter]

This is probably a server bug, and updating the client won't help. In your application, before connecting to a database, you can include the following assignment:

Oracle.NoQueryOptimize := False;