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

From: Subu Korisapati <korisapati_subu_at_bah.com>
Date: Thu, 24 Dec 1998 10:15:55 +0000
Message-ID: <3682145B.F4BDD357@bah.com>

Hello everyone

I am getting the following error message when am trying to look for the invalid objects in the current schema from sql*plus, whereas i dont see any associated relationship between the Sequel that am running and the ERROR message that is being returned.

SQL> R
  1 SELECT OBJECT_TYPE, OBJECT_NAME
  2 FROM USER_OBJECTS
  3* WHERE STATUS = 'INVALID'
ERROR:
ORA-01801: date format is too long for internal buffer

SQL> desc user_objects

 Name                            Null?    Type
 ------------------------------- -------- ----
 OBJECT_NAME                              VARCHAR2(128)
 OBJECT_ID                                NUMBER
 OBJECT_TYPE                              VARCHAR2(13)
 CREATED                                  DATE
 LAST_DDL_TIME                            DATE
 TIMESTAMP                                VARCHAR2(75)
 STATUS                                   VARCHAR2(7)

My environment is :

Oracle7 Server Release 7.3.3.6.0
PL/SQL Release 2.3.3.6.0
VAX/VMS What could be the problem ?

I appreciate your comments.

happy holidays & tia
Subu Received on Thu Dec 24 1998 - 04:15:55 CST