Hello,
(Delphi2006, Oracle9i)
consider the folowing SQL:
SELECT *
FROM V$SQL_PLAN B
WHERE B.ADDRESS=HEXTORAW(:addr)
AND B.HASH_VALUE=TO_NUMBER(:hashv)
DeclareAndSet('addr', otString, sqladdr ); // works ok
DeclareAndSet('hashv', otString, hashval ); // causing problems
//sqladdr =...