define p_start_date = TO_DATE(‘01-Jan-2010’,‘DD-Mon-YYYY’);
I’m using Navigator 6.1 and the above script causes the following error:
11:36:18 ORA-00904: “TO_DATE”: invalid identifier
All scripts I have which have a define statement containing the TO_DATE function now cause this error.
Is this a known issue in Nav 6.1?
I was using an older version before and everything worked fine.