I have a sequence_TOP calling another sequence_LOW calling an extract job.
I send a value '2007-01-01' through sequence_TOP to sequence_LOW and which in turn passes it to the extract job. The parameter type is declared as 'DATE' in both sequence_LOW and extract job.
But when I use this value in SQL query (on oracle) in extract job. It gives error
Code: Select all
ORA-00932: inconsistent datatypes: expected DATE got NUMBER
If I use single quotes in the query to encapsulated the parameter, it works fine.
If it doesn't work this way, what is the use of parameter of type Date (not being sarcastic )