Very Strange Problem of ORA-01843: not a valid month
407338Aug 25 2010 — edited Aug 25 2010Hi gurus,
I am having a rather strange problem with ORA-01843: not a valid month. It is strange because when I run the SQL statement through a client (PowerBuilder), it works and retrieves all the data as expected, but if I run it again for the second time, third time and n time, I get this error. Through debugging, I can see that the date time values supplied are always the same from the first time to the next times. The SQL statement uses bind variables for the date time values.
I have searched this site and googled for this problem. Though other people have the similar problem, mine is unique and no matter what I do, I get this error after the first successful run.
Could anyone help me?
Thank you.
Ben