Access Violation on OraClient10.dll

[Adelson Smania]

Hi.

I have an intermittent problem im my application using DOA both in Delphi 5 and 2007, and Oracle 10.2.0.3. Sometimes, when I call "OracleSession.Connected := False", I receive a "Access violation at address 61CCC2DB in module 'OraClient10.Dll'" error. Below is the call stack of that error, captured by EurekaLog.

Any hints on this?

SrvM2000AdmEst.exe - Oracle.pas - TOracleSession - LogOff - 5791
oci.dll - OCIHandleFree
OraClient10.Dll - OCIHandleFree
OraClient10.Dll - kpufhndl
OraClient10.Dll - kpufhndl
OraClient10.Dll - kpufhndl0
ntdll.dll - LdrGetProcedureAddress
SrvM2000AdmEst.exe - Db.pas - TFields - Clear - 3225
SrvM2000AdmEst.exe - Db.pas - TFields - Changed - 3187
SrvM2000AdmEst.exe - OracleData.pas - TOracleDataSet - SyncDetails - 3944
SrvM2000AdmEst.exe - Db.pas - TDataSet - ControlsDisabled - 8953
SrvM2000AdmEst.exe - Classes.pas - TList - Delete - 1839
ntdll.dll - RtlLeaveCriticalSection
ntdll.dll - RtlImageNtHeaderEx
kernel32.dll - VirtualFreeEx
ntdll.dll - ZwFreeVirtualMemory
SrvM2000AdmEst.exe - Classes.pas - TComponent - SetReference - 7863
ntdll.dll - RtlLeaveCriticalSection
user32.dll - CharUpperBuffA
user32.dll - CharUpperBuffA
OraClient10.Dll - kpufhndl0

Thanks!

 

[Marco Kalter]

Can you tell me something about the application? E.g. multi-session, multi-threaded, DLL sharing, multi-tier, ...? Or is it a straightforward single session, single-tier application that consists of just an executable without any DLL's?

 

[Adelson Smania]

Hi, Marco.

Some information about our ERP application:
- multi-session (each user has a session to communicate with Oracle)
- multi-tier (client, server, database)
- DLL sharing (DOA is in a BPL consumed by serveral EXE files)

The problem occours a few times during the day. In major times, everything goes fine.

Thanks.

 

[Marco Kalter]

Is TOracleSession.ThreadSafe enabled? If not, can you enable it and check if this has any effect?

 

[Adelson Smania]

Thanks for the answer, Marco.

ThreadSafe is disabled. We'll enable it and test it. As soon as I get the results, I'll post an answer.

Best regards!