Intermittant Access Violation reading Oracle CLOB column

Question

User724481447 posted

Hi,

We Have some Intermittant Access Violation reading Oracle CLOB column with the message "Attempted to read or write protected memory. This is often an indication that other memory is corrupt"

We've got the error on dr2("MyColumnName")

 Dim dr2 as OleDbDataReader

 If Not IsDBNull(dr2("MyColumnName")) Then

Answer 1

User269602965 posted

 CLOB, BLOB, BFILE, NCHAR, NCLOB, and NVARCHAR2 data types are not supported by OLEDB

use ODP.NET Oracle.DataAccess.dll instead

Answer 2

User724481447 posted

Thank you for your reply, but it works most of time. So why sometimes it fail ?

Answer 3

User269602965 posted

use ODP.NET Oracle.DataAccess.dll instead