Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Struggling to Insert date into Oracle Database using JDBC reciever

Hello Experts,

25-12-2014 10:52:09 is the format in which I am able to insert the values in the ORACLE 11g database. When I try to use DateTrans to insert the date in this format I am unable to do that as the reciever adapter Prompts : java.sql.SQLException: ORA-01843: not a valid month.

The work around which suggests using a TO_DATE in the constant, then passing the value '02-03-2015 16:29:00','dd-MM-yyyy hh:mm:ss' in the TO_DATE and mapping it with the target date field prompts another error :ORA-01858: a non-numeric character was found where a numeric was expected. I have passed hasQoute value as NO.

EDATUV gives me the date while EZEIT gives me the time.






Delivery date Queue

Please help.

Former Member
Former Member replied

Issue resolved.


this should be the value in second constant.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question