Skip to Main Content
Forums

Oracle Database Discussions

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!

ORA-01843 Not a valid month

2753798Oct 2 2014 — edited Oct 3 2014

Hello gurus,

I have a desktop application, when I load a form which has a date field, I have the error ORA-01843 Not a Valid Month, I execute the same application in another PC and It's OK.

  1. My REGEDIT NLS_LANG , I have used many values: AMERICAN_AMERICA.WE8MSWIN1252, SPANISH_SPAIN.WE8MSWIN1252, LATIN AMERICAN SPANISH_PERU.WE8MSWIN1252

  2. I have the value NLS_DATE_FORMAT = DD/MM/YYYY, also I have changed to DD/MM/RRRR

  3. I have Oracle Client 11g 11.2.0.1.0

  4. These are the paremetes of the database

I have done many changes in the configuration.

Only my PC has the problem ORA-01843, others PC don't have any problem. I have uninstall Oracle 11g, I installed Oracle 10g and still the error persists.

Thanks in advance for your answers.

nls_parameters.JPG
This post has been answered by 2753798 on Oct 2 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 31 2014
Added on Oct 2 2014
#general-database-discussions
12 comments
3,153 views