Re: ODP.NET 10.2

On Nov 13, 7:41 am, gotpewi <peter.williams..._at_gmail.com> wrote:
> 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

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 -- Received on Mon Nov 16 2009 - 18:01:32 CET