We are currently migrating an application that uses
SQLJ/DB2 to SQLJ/Oracle and we are getting some on SELECT with Host varialble
Where columnB = :colB
It always return with a not found even if the record do exist. If we hardcode the value for colb above i.e. “where column = ‘valueB’ it works fine. We have checked and double checked our setup for translator and runtime and jdbc drivers and looks good.
We are currently using Oracle 11g