Probloaam with ODP.NET Bind Parameter in Oracle 8.16

microsoft.public.dotnet.framework.adonet

30 Jun 2006 5:50 PM

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.

1 Jul 2006 7:39 AM

Frans Bouma [C# MVP]

mablao wrote:

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