This content has been marked as final. Show 1 reply
I have the same problem. It is caused by different NLS settings for session when job was created and session where you setup parameters.
Be sure that both sessions have same NLS settings especially NLS_DATE_FORMAT.
In dbms_scheduler_jobs there is column with NLS parameters.
If you can't assure same NLS settings in both sessions change you DATE parameter to string and put date then as a string in format you want. But don't forget to use to_date(string, format) function in job to convert string back to date.