DOA 4.1 and Access Violation in orageneric11.dll

[pal]

Hi!

I am using Delphi 2007 and DOA v 4.1.
When I use the Oracle 11 client i get an error: Access violation at address 03C701E9 in module 'orageneric11.dll'. Write of address 00000000.

From what I have gathered of information by debuging is that the error occurs when I set the TOracleDataset to either Edit or try to do a post.

I have also debuged the DOA source files and concluded that there is an issue running CloseDMLQuery. When the "FieldList" is about to be cleared is when the access violation occurs.

The error is difficult to reporoduce since it's not consistent so I understand that it's hard to answer my question on why this happens. Therefore I am asking if there is any known issues regarding Oracle 11 and DOA 4.1? I have googled it and looked through the forum here, but I can't find any sollution for this problem.

I will debug some more on this problem and post back here if I find anything.

Edit: I forgot to mention that it works fine with the oracle 10 client.

 

[Marco Kalter]

Is this perhaps a multi-threaded application? Does it help if you change TOracleSession.ThreadSafe?

 

[pal]

This is a multithreaded application yes, and the ThreadSafe property is set to True.

Some more information I have gathered is that the table I get data from has a XMLType column, but the column is not defined in the select clause. This might be related to thread
"#43648: TOracleObject: Invalid handle error w/ NULL XMLType in query".

I will await for a bugfix for the issue described in thread #43648 before pursuing this problem anymore.

 

[pal]

Hi again!

I have done some more debuging on this issue and found out that it is related to the same issue you are having in your PL/SQL developer software. Ref. thread "#44126 Quering a table with xmltype columns gives an Access Violation".

The query fails if there exsists XMLTYPE columns with NULL-values, in the table I select from. It is only related to XMLTYPE columns, not CLOB and BLOB -columns.

The error I get is: Access violation at address 04CD72D8 in module 'OraOCIEI11.dll'. Read of address 0D04001C.

The exception is caused by this line in the unit "OracleTypes" in method "TFieldData.FreeObjects":
OCIObjectFree(Senvhp, Serrhp, Instance, OCI_DEFAULT);

Delphi version: Delphi 2007.
DOA version: 4.1.1.0
Oracle client version: 11.2.0.1

I hope you will be able to fix this quickly as we have customers waiting for this to be fixed.

 

[rguillen]

I having similar problems.

02/29/2012 23:26:48 Error: Access violation at address 62CC7597 in module 'OraClient11.Dll'. Read of address 00000010

or

02/29/2012 22:24:07 Error: Access violation at address 00571770 in module 'AppServEtiquetas.exe'. Read of address 00000010

or

09/14/2012 10:51:40 Error: Access violation at address 02AA9A93 in module 'oran11.dll'. Read of address 00000180

In this case is a DataSnap application using DOA
I'm not using XMLType or CLOB, BLOB columns.

RAD Studio XE and RAD Studio XE2
Oracle client version 11.2.0.0
Direct Oracle Access 4.1.1.0

 

[Marco Kalter]

Is this a multi-threaded application? If so, make sure that TOracleSession.ThreadSafe is set to True if multiple threads access the same session component instances.

 

[pal]

I having similar problems.

02/29/2012 23:26:48 Error: Access violation at address 62CC7597 in module 'OraClient11.Dll'. Read of address 00000010

or

02/29/2012 22:24:07 Error: Access violation at address 00571770 in module 'AppServEtiquetas.exe'. Read of address 00000010

or

09/14/2012 10:51:40 Error: Access violation at address 02AA9A93 in module 'oran11.dll'. Read of address 00000180

In this case is a DataSnap application using DOA
I'm not using XMLType or CLOB, BLOB columns.

RAD Studio XE and RAD Studio XE2
Oracle client version 11.2.0.0
Direct Oracle Access 4.1.1.0

In my case it's a multi-threaded application, but I have set the threadsafe property to True. I would guess, from the DOA source code i reffered in my previous post, that this is an issue for all Objects and object-references (XMLType is an Oracle type which is refered to as an object in DOA (otObject)), although I have not tested with any other objects than the XMLType.

CLOBS and BLOBS do not have this issue since they are built-in datatypes in oracle.

Can you confirm that your SQL, that fails, includes fields that holds an object or an object-reference?

 

[James Savage]

I'm also having this problem when querying an XMLTYPE column. It seems I can run the same select query once or twice before getting the error:
Access violation at address 10D001E9 in module 'orageneric11.dll'. Write of address 00000000.

If I run the same select query from PL/SQL Developer I get similar results - it works ok the first couple of times, and just keeps running and never returns results (doesn't actually error though).

I also have customers waiting on this so any feedback would be appreciated.

 

[tcogill]

I'm having this issue also. As a work around I've started quering all XMLType columns like this:

select col1, col2, col3,
xmlserialize(content xml_col as clob) as xml_col
from any_table;

I'm on Oracle 11.2.0.3.0, PLSQLDeveloper 9.0.5.1648. A coworker is also seeing this on 9.0.6.1665.

- Tim

 

[Quido]

Has anyone resolved this issue yet? We are getting the same error, either in orageneric11.dll or oraociei11.dll.

Using:
* Multi-threaded application, but sessions are never used simultaneously from more one thread. Each running thread has it's own Oracle session.
* Oracle Instant client 11.2.0.1
* DOA 4.1.1
* Delphi 2006
* TOracleSession.Threadsafe = true

We are not using any XMLTypes.

Edit: this error occurs in the LogOn sometimes, but also in other DB actions. However, it appears only to occur in applications that use Oracle Advanced queues (dbms_aq package).