Database Administration (MOSC)

MOSC Banner

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

edited Jun 19, 2018 1:50PM in Database Administration (MOSC) 9 commentsAnswered

Hi,

When recording some parameters, the following error message:

ORA-20000: ERROR EN LA FUNCION

ORA-01801: DATE FORMAT IS TOO LONG FOR INTERNAL BUFFER

ORA-06512:

My database is Oracle 11gR2

SQL> select value from v$nls_parameters
  2  where parameter='NLS_DATE_FORMAT';

VALUE
----------------------------------------------------------------
DD-MON-RR

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center