I am using a query to fetch records from a table in a iterative manner. In
this situation, let's say the
table has 600 records but it's able to fetch only 599 records. For the
last record I am getting the following error:
ORA-01801: date format is too long for
I checked the DB for the date format and it is the same for all
the records, so why
getting this error for one record only and other 599 records are
getting processed successfully?
Could anyone help me to understand why I am getting the ORA-01801 error?
To diagnose any
error, you start by using the
oerr utility to display the ORA-01801 error:
format is too long for internal buffer
The date format string was too long to process. This should occur only if
several long literals are specified as part of a date.
Remove long literals from the date format string.