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

    Incremental Load from Oracle and Date issues

      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?