My Oracle Support Banner

ORA-01830: Date Format Picture Ends Before Converting Entire Input String (Doc ID 1602161.1)

Last updated on MAY 07, 2018

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

ORA-01830: date format picture ends before converting entire input string

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.