Crash when using TOracleDataset

[ltd]

Hi,

i have a strange crash when using the oracle dataset.
Oracle server 10.2.0.1.0
Oracle Client 10.2.0.1.0
DOA 4.0.6

I have produced a reduced test:

I have a dataset with a valid SQL statement and a button with the following code:

{
data->Active=false;
data->Active=true;
}

The following scenario works without any problems.

1. Press the button to refresh the query
2. With SQLplus delete the complete table and commit the transaction
3. Press the button again to refresh

The following crashes:

1. Press the button to refresh the query
2. With SQLplus truncate the table ( no commit needed)
3. Press the button again to refresh
Then i get an access violation

I have a workaround for the crash:
If i modify the code in the button to

{
data->Active=false;
data->CloseAll();
data->Active=true;
}

i can truncate the table without the access violation.
When i look into the SQLmonitor it also reports the access violation so i guess it is a DOA problem and not an OCI bug.

Regards,

Lars

 

[Jens Fudickar]

I would try to deactivate the optimization of the datasets.

Greetings
Jens

 

[Neil Crawforth]

Originally posted by Jens Fudickar:
I would try to deactivate the optimization of the datasets.

We're experiencing the same problem, and this fixes it. What implications does turning off these optimizations have for performance?

 

[Marco Kalter]

This is actually an Oracle 10.2 bug. The performance implications depend on the query. If it is a short query that is executed many times with the same SQL text, then there may be a difference. If the query is long and/or is not executed often, then there will not be any measurable difference.

 

[Neil Crawforth]

Thanks for your help. Is there an Oracle bug number for this?

 

[Marco Kalter]

I don't have a number, but I've heard from a customer that it's fixed in 10.2.0.2. We have not been able to reproduce the bug ourselves.