SQL Language (MOSC)

MOSC Banner

getting java.sql.SQLException: ORA-01840: input value not long enough for date format

edited Aug 21, 2015 10:00AM in SQL Language (MOSC) 1 commentAnswered

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_CHARACTERSETAL16UTF16
NLS_LANGUAGEAMERICANNLS_LANGUAGEAMERICAN
NLS_TERRITORYAMERICANLS_TERRITORYAMERICA
NLS_CURRENCY$NLS_CURRENCY$
NLS_ISO_CURRENCYAMERICANLS_ISO_CURRENCYAMERICA
NLS_NUMERIC_CHARACTERS.,NLS_NUMERIC_CHARACTERS.,
NLS_CHARACTERSET

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