Access violation in 'orageneric12.dll' when using DOA 4.1.1 for Delphi 5 with Oracle client 12.1

We have a Delphi 5 Windows application that uses DOA 4.1.1 to connect to an Oracle 12c server using an Oracle 12.1 client.

With this configuration, we keep getting some random access violation errors in module 'orageneric12.dll'.

With the same Delphi 5 application and still using DOA 4.1.1, we are NOT getting any errors when using an Oracle 10.2 client connection to the same Oracle 12c server.

Can you please tell me if DOA 4.1.1 for Delphi 5 officially support an Oracle 12.1 client ? If it supports it, do you have any clue for these exceptions.

Thanks,

Michel W.

Yes, any 4.x version should work just fine with an Oracle12c Client. Do you know what kind of activity triggers this access violations?

Random access violations have plagued us since v7.0, from 10g through 12. I believe I've pinned down exactly what causes them and have a workaround... whether your crashes are related or not is unknown.

What we see is that anytime there's a lob/clob/xml/obj field in the query, a select * will crash after 99 records. So we set our initial retrieval to 99 records, and try to avoid the '*'. We also try to specify the fields individually, and do a .getclobval() on the object fields, as such:

SQL Query

select excptn_id,  code_src,  error_desc,  esclt_lvl,
       t.stack_trc.getclobval() stack_trc, 
       ora_errm,   ora_code,  create_dt 
from   exception_log;

Since starting these practices, I have never had an Access Violation error.

Interestingly, if I right-click a table with a clob/xml field and pick 'Query Data', PL/SQL Developer adds the getclobval() automatically. If I drag and drop the table into the editor and choose to generate a select statement, the fields are listed individually, but getclobval() is not added, and will crash.