getting java.sql.SQLException: ORA-01840: input value not long enough for date format
I am running one custom report in xml format. When i run the report in 10g it works fine and fetch the data. But when i run same report in 11g , i am getting "java.sql.SQLException: ORA-01840: input value not long enough for date format" error.
I am attaching the log files from both instances.
NLS_DATABASE PARAMETERS as below
11g 10g
NLS_NCHAR_CHARACTERSET | AL16UTF16 | ||
NLS_LANGUAGE | AMERICAN | NLS_LANGUAGE | AMERICAN |
NLS_TERRITORY | AMERICA | NLS_TERRITORY | AMERICA |
NLS_CURRENCY | $ | NLS_CURRENCY | $ |
NLS_ISO_CURRENCY | AMERICA | NLS_ISO_CURRENCY | AMERICA |
NLS_NUMERIC_CHARACTERS | ., | NLS_NUMERIC_CHARACTERS | ., |
NLS_CHARACTERSET |