dbTalk Databases Forums  

ODP.NET 10.2

comp.databases.oracle.tools comp.databases.oracle.tools


Discuss ODP.NET 10.2 in the comp.databases.oracle.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
gotpewi
 
Posts: n/a

Default ODP.NET 10.2 - 11-13-2009 , 06:41 AM






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

Reply With Quote
  #2  
Old   
Mark D Powell
 
Posts: n/a

Default Re: ODP.NET 10.2 - 11-16-2009 , 11:01 AM






On Nov 13, 7:41*am, gotpewi <peter.williams... (AT) gmail (DOT) com> wrote:
Quote:
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 --

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.