I found several threads on Metalink regarding this. Oracle says it is a
bug. Depending on the version of Oracle that you have, you will need to
apply a patch.
> -----Original Message-----
> From: Christine Turner [SMTP:Christine.Turner_at_IPS-Sendero.com]
> Sent: Tuesday, August 01, 2000 10:17 AM
> To: Multiple recipients of list ORACLE-L
> Subject: ORA-01801
>
> You know I just love the error message book, it is so helpful! NOT!
> Anyways, hello all, I'm running into a problem when I do a SELECT * FROM
> TABLE. I'm receiving a ORA-01801, data format is too long for internal
> buffer. According to the messages and code book the action I am supposed
> to take is to remove long literals from the date format string. WHAT???
> All this from a select *????
>
> Any comments appreciated. Please help!!!
>
> Thanks In Advance!
> Take Care,
> Christine Turner
> Database Administrator
> IPS-Sendero
> Scottsdale, Arizona
> Phone: (800) 321-6899 ext. 3286
> Fax: (480) 946-8224
> E-mail: christine.turner_at_ips-sendero.com
>
>
> --
> Author: Christine Turner
> INET: Christine.Turner_at_IPS-Sendero.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Aug 01 2000 - 11:19:01 CDT
