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
What is the data type in DB2 and Oracle for 'columnB'?