Skip to Content
avatar image
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

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    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

  • avatar image
    Former Member
    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