Skip to Content
author's profile photo Former Member
Former Member

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.

1.

1.a

1.b

2.

3.

Delivery date Queue

Please help.

mapping 1.PNG (14.5 kB)
mapping 2.PNG (3.8 kB)
mapping3.PNG (10.0 kB)
mappin 1a.PNG (48.9 kB)
mapping 1b.PNG (51.1 kB)
Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 25, 2014 at 06:47 AM

    Issue resolved.

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

    this should be the value in second constant.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 25, 2014 at 06:17 AM

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

    DATE/TIME datatypes and Oracle Database

    Add comment
    10|10000 characters needed characters exceeded