Home » SQL & PL/SQL » SQL & PL/SQL » Error while selecting the data
Error while selecting the data [message #206072] Tue, 28 November 2006 09:43 Go to next message
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.
Re: Error while selecting the data [message #206089 is a reply to message #206072] Tue, 28 November 2006 11:50 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
Re: Error while selecting the data [message #206100 is a reply to message #206089] Tue, 28 November 2006 14:25 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Is hs_mmv_cmcdr a view by any chance?
Re: Error while selecting the data [message #206218 is a reply to message #206100] Wed, 29 November 2006 03:54 Go to previous message
raghavs_dvg
Messages: 8
Registered: November 2006
Location: mumbai
Junior Member
hs_mmv_cmcdr is a table
Previous Topic: dbms_job interval
Next Topic: how to find duplicate record ?
Goto Forum:
  


Current Time: Sun Dec 11 00:10:25 CST 2016

Total time taken to generate the page: 0.10839 seconds