Struggling to Insert date into Oracle Database using JDBC reciever

[Former Member]

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.

1.

1.a

1.b

2.

3.

Delivery date Queue

Please help.

[Former Member · Accepted solution]

Issue resolved.

','DD-MM-YYYY  HH:MI:SS')

this should be the value in second constant.

[Former Member]

FYI. I have referred the below document. But I have not found the solution