The cause of this error could be any of the following reasons
1.Using wrong DD/MM sequence / incorrect NLS_DATE_FORMAT This happens a lot when you see data coming from US (where the Monthis normally written before the day) but the format in the application is still the "european" style. (where the day is written before the month) or inverse of course
2.Using a different Languagewith the MON mask, which can be much harder to spot.
3.Using a complete incorrect NLS_DATE_FORMAT: Suchas trying to insert a "written" month name but are using a "numeric"
To get your Database's NLS_DATE format use this query
SELECT *from NLS_INSTANCE_PARAMETERS;
SELECT *from NLS_DATABASE_PARAMETERS;
edit | flag
Gokul A Answered on: Dec 07, 2011 at 2:11AM
Post your Answer
Welcome to Ask Amoeba! This is 100% free and interactive site for sharing professional Questions and Answers, Opensource projects, Interview questions. Learners, beginners, Experts stop and share your knowledge and ideas!