I have a loop I've created using a system calendar to output start and end dates for a query that is set up using the import wizard. The loop dataset variable name is Period and the query result columns are named startdate and enddate. In the import wizard predicate I have specified :Period.startdate and :Period.enddate but TDP isn't recognizing the parameter and is returning: ORA-01858: a non-numeric character was found where a numeric was expected.
Are either of these syntactically correct and should the import wizard object be able accept these values?
between to_date(':Period.startdate','MM-DD-YYYY') AND to_date(':Period.enddate','MM-DD-YYYY') - Returns ORA-01858: a non-numeric character was found where a numeric was expected
between to_date('#Period.startdate#','MM-DD-YYYY') AND to_date('#Period.enddate#','MM-DD-YYYY') - Returns ORA-00907: missing right parenthesis