Printable View
ORA-01801: date format is too long for internal buffer
Our application is running 24X7 in a customer place and they are facing this particular error at times. Then they need to restart the Database to resolve this error. In Application programmatically absolutely no issues regarding date formats.
DB version is 9.2.0.5.
Can anybody give inputs what could be the reason and what needs to be done.
Regards
Srini.
r u using Oracle Forms..
Not sure just check if below helps...
http://forums.oracle.com/forums/thre...art=0&tstart=0
The below error was due to non -valid date for birth date of participant in table. While I convert those dates into century am getting the below error
ORA-01801: date format is too long for internal buffer
The Code I used is TO_CHAR (p.birth_date, 'CC') NOT IN ('18','19','20','21'), to check whether dates are falling into given century.
When below dates cant able to convert into century format using above to_char function, here century is ‘100’ but the to_char can have capable to handle only 2 digit for century.
Below are the lists of participant having issue
PART_ID BIRTH_DATE YYYY-MM-DD
211379396 12/31/99 9999-12-31
238335183 12/31/99 9999-12-31
239264421 12/31/99 9999-12-31
238951412 12/31/99 9999-12-31
Solution : need to update the date field with valid date