Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ODP.NET 10.2

4 views
Skip to first unread message

gotpewi

unread,
Nov 13, 2009, 7:41:00 AM11/13/09
to
Hi,
I'm having a problem with setting the "InitialLOBFetchSize = -1" in
order to optimize the performance. When looking at the documentation
this should be OK but the application is crashing or returning with
corrupt data. Does anyone knows how to succesfully use this parameter
setting for either the OracleDataReader or OracleCommand object?

My development environment is as follows:
- Oracle Database 11g Enterprise Edition Release 11.1.0.7.0
- Visual Studion 2008 using C# and .Net Framework 3.5

The documentation I've been looking at is "Oracle Data Provider
for .NET Developers Guide 10.2".

N.B I've posted a similar message at comp.databases.oracle.misc as I
don't know where it belongs

Regards Peter

Mark D Powell

unread,
Nov 16, 2009, 12:01:32 PM11/16/09
to

Peter, I found a couple of bug resports that might apply. You can
check them on the My Oracle Support site if you have support.


Bug 6945432 - Win: Data truncation when initialLOBFetchSize is set [ID
6945432.8]

Lob Data Truncated When Using InitialLOBFetchSize [ID 731799.1]

Oracle Data Provider for .Net Release 10.2.0.3.02 Release Notes (64-
bit) [ID 436020.1]

HTH -- Mark D Powell --


0 new messages