Devart Forums

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

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.

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