Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01861: literal does not match format string

user12180448Apr 12 2011 — edited Apr 12 2011

This is the error I get right now.
Looked for solution but no success - maybe some of You met this description: 11g, jDev 11.1.1.4, DB adapter, update/insert action, date field stored/updated to DB only in case posted to TIMESTAMP same format as DB NLS date format is. Otherwise this error:

java.lang.Exception: oracle.sysman.emSDK.webservices.wsdlapi.SoapTestException: Exception occured when binding was invoked. Exception occured during invocation of JCA binding: "JCA Binding execute of Reference operation 'update' failed due to: DBWriteInteractionSpec Execute Failed Exception. update failed. Descriptor name: [CreateLeaseListEbizReqDBAdapterUpdate.XxaqvPnLeaseSoaInterface]. Caused by java.sql.BatchUpdateException:
ORA-01861: literal does not match format string ..
_OR_
ORA-01843: not a valid month

Overall got a feeling that statement executed is simple to_date function without date mask. Any ideas? Some misconfiguration?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 10 2011

Added on Apr 12 2011

#11g, #bpel, #oracle, #process, #soa, #soa-process-management, #soa-suite-discusssions

0 comments

434 views