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

From: Gerrit-Jan Linker <linker_at_oraxcel.com>
Date: 2000/04/06
Message-ID: <8cho2v$mok$2@news5.svr.pol.co.uk>#1/1

This is what the oracle documentation says. It should not have happened. Anyone else?

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

Cause:The date format string was too long to process. This should only occur if several long literals are specified as part of a date.

Action:Remove long literals from the date format string.

--
Gerrit-Jan Linker

web:     http://www.oraxcel.com
email:  gjlinker_at_oraxcel.com

Oraxcel: Linking Oracle to Excel
OraCodes: Explaining ORA- error codes
OraSQL: Explaining Oracle SQL syntax
OraDebug: PL/SQL debugger
OraWeb: Oracle access from IE

sheldon <txdNOtxSPAM_at_poboxes.com.invalid> wrote in message
news:1b98b668.2b97d63f_at_usw-ex0105-036.remarq.com...


> I am using this function in my store procedure

>  to_char(sysdate,'yyyy/mm/dd hh24:mi:ss')

> usually it works fine, but sometimes it fails and the error

> message is:

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

> How can this happen, Can I adjust the internal buffer?What

> should I do for it?

>

> sheldon

>

>

> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network

 *


> The fastest and easiest way to search and participate in Usenet - Free!

>

Received on Thu Apr 06 2000 - 00:00:00 CDT