Probloaam with ODP.NET Bind Parameter in Oracle 8.16 -- dotnet ado.net

mablao
6/30/2006 10:50:20 AM

Hi,
I=B4m having a problem using Bind Parameter with Oracle 8.1.6
The same query runs ok on a Oracle 8.1.7 or later... but on Oracle
8=2E1.6 the first oracleReader.Read() statement takes a very long time
(10 minutes to fetch 440 registers).
The query is not too simple, it's use some joins and outter joins.
If I run the query with the parameter in the commandtext (without bind
parameter) it runs ok ( 2 seconds to fetch the same 440 registers).
Could anyone help me ??

Thanks.

Frans Bouma [C# MVP]
7/1/2006 12:39:44 AM

[quoted text, click to view]

Isn't 8.1.6 the version before 8i? ODP.NET supports 8i and up, not a
version below it.

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)

dotnet ado.net : Probloaam with ODP.NET Bind Parameter in Oracle 8.16