Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Problem ODP.NET Bind Parameter in Oracle 8.1.6

Problem ODP.NET Bind Parameter in Oracle 8.1.6

From: mablao <mablao_at_gmail.com>
Date: 30 Jun 2006 10:53:31 -0700
Message-ID: <1151690011.506568.94210@b68g2000cwa.googlegroups.com>


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. Received on Fri Jun 30 2006 - 12:53:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US