Oracle Access Violation, ORA805.DLL

[Harris007]

Have a TOracleDataSet. When Optimize is set to True, sporadically get the Oracle Access Violation in ORA805.DLL error message when trying to issue an Open on the dataset. With Optimize set to False, works fine. Any idea what is causing this, and if it will fixed soon?

 

[Marco Kalter]

What is your Direct Oracle Access version, and what is the query and table definition? Have you tried the same on a different client?

------------------
Marco Kalter
Allround Automations

 

[Harris007]

Tried other clients, same thing. Below is th einfo you requested.

--- The query

SELECT timesheet.rowid,
TO_CHAR(timesheet.start_on_duty_date, 'DD/MM/YYYY HH24"h') start_on_duty_date_str,
TO_CHAR(timesheet.end_on_duty_date, 'DD/MM/YYYY HH24"h') end_on_duty_date_str,
TO_CHAR(timesheet.end_off_duty_date, 'DD/MM/YYYY HH24"h') end_off_duty_date_str,
DECODE(timesheet.all_off_duty_flag, 1, '

 

[Marco Kalter]

And your Direct Oracle Access version?

------------------
Marco Kalter
Allround Automations

 

[Harris007]

version 3.4.5.1

 

[Marco Kalter]

Hmm, I can't immediately find any possible cause for this Net8 AV. Perhaps you can upgrade to Net8 8.1 and retry it?

------------------
Marco Kalter
Allround Automations