This content has been marked as final. Show 2 replies
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?