2 Replies Latest reply: Jun 24, 2014 3:13 AM by Sunil Chauhan RSS

    Incremental Load from Oracle and Date issues

    Boris Kacevich

      Hi all,

       

      I'm writing an incremental load script to load a table from oracle.

      my Water mark is a DBTIMESTAMP from oracle.

       

      When I load from the latest QVD the max DBTIMESTAMP I save it into a variable in the script.

      Then I try to run a SQL query on the oracle DB and do an expression:

      WHERE DBTIMESTAMP> vVariable

       

      I get an error: expected a date, got a number

       

      when I get the max DBTIMESTAMP from the QVD I put in in the date function but still it doesn't work.

       

       

      Can someone who has dealt with oracle loads assist me?

       

       

      Thanks,

       

      Boris