passing date as parameter through sequence
Posted: Wed Jun 06, 2007 10:41 am
I found few topics similar to this, but this one is somewhat different.
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
I even tried passing time - '2007-01-01 00:00:00'
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
)
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
![Embarassed :oops:](./images/smilies/icon_redface.gif)