DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-01801: date format is too long for internal buffer

  1. #1
    Join Date
    Dec 2008
    Posts
    1

    ORA-01801: date format is too long for internal buffer

    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.

  2. #2
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    r u using Oracle Forms..

    Not sure just check if below helps...

    http://forums.oracle.com/forums/thre...art=0&tstart=0
    Rgds
    Parag

  3. #3
    Join Date
    Apr 2013
    Posts
    1
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width