Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Very Strange Problem of ORA-01843: not a valid month

407338Aug 25 2010 — edited Aug 25 2010
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 22 2010
Added on Aug 25 2010
9 comments
1,469 views