Probloaam with ODP.NET Bind Parameter in Oracle 8.16

[mablao]

Hi,
I´m 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.1.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]]

Hi,
I´m 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.1.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 ??

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#)
------------------------------------------------------------------------