Hi
We have an application job that can be run on ad-hoc basis. The job calls a pl/sql procedure through a unix shell script, which in turn triggers several other procedures.
One of these procedures is failing with an error
ORA-01861: literal does not match format string
I think this is while updating a date column.
Now comes the astonighing part - when I debug the same procedure step by step from Toad.. I do not get any errors :(
whats wrong? has this got something to do with nls_date_format?
if needed, I will paste the code here. Please advise.
Thanks,