1 Reply Latest reply: Jul 29, 2013 2:32 PM by jschellSomeoneStoleMyAlias RSS

    Help Pls! Issue with SQLJ and host variable always not found




      We are currently migrating an application that uses
      SQLJ/DB2 to SQLJ/Oracle and we are getting some on SELECT with Host varialble


      Select columnA

      From tableA

      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