Re: [cx-oracle-users] DatabaseError: ORA-01843: not a valid month

[Joel S. <js...@cp...>]

What does your code look like? Do you know what your NLS setting is for your session? You might need to set it yourself before passing the dates around.

-joel

From: Andrey Nikolaev [mailto:nik...@gm...]
Sent: Sunday, April 21, 2013 6:51 PM
To: cx-oracle-users
Subject: Re: [cx-oracle-users] DatabaseError: ORA-01843: not a valid month

Hello,
I just started using cx_Oracle and came across an issue related to Oracle Date datatype. I am getting an error ORA-01843 every time I need to do anything with dates.


A similar problem is described on the stackoverflow: http://stackoverflow.com/questions/15396241/cx-oracle-ora-01843-not-a-valid-month-with-unicode-parameter

Has anybody come across this issue? I believe something is wrong with how I use cx_Oracle but I can't find out what. I tried the same case as in the stackoverflow post and got the same error.

--
Thanks,
Andrey Nikolaev                            mailto:Nik...@gm...<mailto:Nik...@gm...>
________________________________
Confidentiality Note: This electronic message transmission is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. If you have received this transmission, but are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this information is strictly prohibited. If you have received this e-mail in error, please contact Continuum Performance Systems at {203.245.5000} and delete and destroy the original message and all copies.