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

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

    7c0c5970-9e5d-43a2-8dd2-a65980de5b53

      Hi,

       

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

       

      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

       

      Thx,

      Ed