Re: Problem ODP.NET Bind Parameter in Oracle 8.1.6

On 30 Jun 2006 10:53:31 -0700, "mablao" <mablao_at_gmail.com> 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 ??
>
>Thanks.

8.1.6 was full of bugs and desupported in the previous milennium. 8.1.7 is desupported too.
Get something less paleolithic like 9iR2, or better still: 10gR2

--
Sybrand Bakker, Senior Oracle DBA