OraFAQ Forum: SQL & PL/SQL » Error while selecting the data

Home » SQL & PL/SQL » SQL & PL/SQL » Error while selecting the data

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error while selecting the data [message #206072]

Tue, 28 November 2006 09:43

raghavs_dvg
Messages: 8
Registered: November 2006
Location: mumbai

Junior Member

Hi All,

I able to store the data,copied from sql-server into oracle database(9i). In that some of the fields are of datetime type

in oracle i have created the date type for those having datetime type.

While selecting the data in oracle it is giving the following error message

[COLOR=blue]SQL> select * from hs_mmv_cmcdr where rownum < 3 ;
ERROR:
ORA-01801: date format is too long for internal buffer

no rows selected[/COLOR]

Please Help me out in this issue.

Report message to a moderator

Re: Error while selecting the data [message #206089 is a reply to message #206072]

Tue, 28 November 2006 11:50

Littlefoot
Messages: 21824
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

This is what Oracle says about it:

Oracle

ORA-01801 date format is too long for internal buffer

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

Action: Remove long literals from the date format string.

Report message to a moderator