Intermittant Access Violation reading Oracle CLOB column   

We have an application that gets intermittant access violation errors
reading from an Oracle table that contains a CLOB column.  If the
application runs again, with no changes, it will run to completion.  The
problem is not associated with a single table.  We have gotten it on
different tables.  However, all of the tables we have had this problem with
have a CLOB column.

Has anyone seen this problem?

[System.AccessViolationException]: Attempted to read or write protected
memory. This is often an indication that other memory is corrupt.
   at System.Data.Common.UnsafeNativeMethods.IRowset.GetData(IntPtr hRow,
IntPtr hAccessor, IntPtr pData)
   at System.Data.OleDb.OleDbDataReader.GetRowDataFromHandle()
   at System.Data.OleDb.OleDbDataReader.GetValueBinding(MetaData info)
   at System.Data.OleDb.OleDbDataReader.GetValues(Object[] values)
   at
System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.GetValues(Object[]
values)
   at System.Data.ProviderBase.SchemaMapping.LoadDataRow()
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset,
DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32
startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object
parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable,
IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
...
...
...

Best regards,

Metro Sauper

date: Thu, 27 Mar 2008 19:14:35 -0400   author:   Metro Sauper am

RE: Intermittant Access Violation reading Oracle CLOB column   

Hello Metro,

As far as I know, System.Data.Common.UnsafeNativeMethods.IRowset.GetData() 
method will call ODBC driver to retrive data from oracle database. This 
issue should related with Oracle Db Driver. Could you let me know which 
odbc driver you are using for connection Oracle database? 

Have a great day,
Best regards,
Wen Yuan

Microsoft Online Community Support 
Delighting our customers is our #1 priority. We welcome your comments and 
suggestions about how we can improve the support we provide to you. Please 
feel free to let my manager know what you think of the level of service 
provided. You can send feedback directly to my manager at: 
msdnmg@microsoft.com.
==================================================
Get notification to my posts through email? Please refer to 
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues 
where an initial response from the community or a Microsoft Support 
Engineer within 1 business day is acceptable. Please note that each follow 
up response may take approximately 2 business days as the support 
professional working with you may need further investigation to reach the 
most efficient resolution. The offering is not appropriate for situations 
that require urgent, real-time or phone-based interactions or complex 
project analysis and dump analysis issues. Issues of this nature are best 
handled working with a dedicated Microsoft Support Engineer by contacting 
Microsoft Customer Support Services (CSS) at 
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

date: Fri, 28 Mar 2008 11:13:45 GMT   author:   (Wen Yuan Wang [MSFT])

RE: Intermittant Access Violation reading Oracle CLOB column   

Hello Metro,

Have you resolved the issue so far? We haven't heard from you a couple of 
days.
If the issue still persists, could please let us know which odbc driver you 
are using in the application? In my opinion, this should be an ODBC driver 
issue.

Please feel free to let us know, if you have any more concern. It's my 
pleasure to assist you.
Have a great day,
Best regards,
Wen Yuan

Microsoft Online Community Support 
Delighting our customers is our #1 priority. We welcome your comments and 
suggestions about how we can improve the support we provide to you. Please 
feel free to let my manager know what you think of the level of service 
provided. You can send feedback directly to my manager at: 
msdnmg@microsoft.com.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

date: Tue, 01 Apr 2008 11:04:16 GMT   author:   (Wen Yuan Wang [MSFT])