"Explain Plan" bind variable error

ysyang · Post by **ysyang** » Wed 11 Jan 2006 15:35

Hi

I'm use Delphi 6, ODAC 5.55.0.21
Oracle9i,TSmartSQL

sql =
----------------------------------------------------------------------
explain plan set statement_id='1000' into PLAN_TABLE For
select TO_DATE( :strDt, 'yyyyMMdd' )
from dual
-----------------------------------------------------------------------
when TOraSession.Option.Net = True
"ora-01006 bind variable does not exist"
but TOraSession.Option.Net = False not error

Please Help

Paul · Post by **Paul** » Fri 13 Jan 2006 15:33

We reproduced your problem. ODAC does not change SQL and and performs no specific transformations for "explain plan" statement.
It looks like a bug of Oracle 9i and and it is fixed on Oracle 10.

ysyang · Post by **ysyang** » Mon 16 Jan 2006 00:57

I know not happen error on Oracle 10g.
when OCI login ,no error on Oracle 9i
but when Net login , error on Oracle 9i

Thanks in advance