ORA-01830: Date Format Picture Ends Before Converting Entire Input String

(Doc ID 1602161.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Service Bus - Version 11.1.1.3.0 and later
Information in this document applies to any platform.

Symptoms

While executing a query from a J2EE application running on Solaris 10 connecting to Oracle ExaData 11G, we encounter the error

However we do not get the same error when running the exact same query on Solaris 9 against the same Oracle Exadata 11G instance. In all cases, we are using the same Oracle JDBC driver, same code base, same Oracle DB instance.


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms