Skip to Content
avatar image
Former Member

Problem in updating DataBase Table

Hi,

In my RFC 2 JDBC scenario, I am getting an error as follows.

'Java.sql.sqlexception - ORA -01861':literal doesnt match format string.

Can you help on how to solve this?.

Thanks,

Raj.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 03, 2006 at 10:09 PM

    Hi Raj,

    It means that you are trying to populate a field with value thats not valid for the format of the string.

    Eg. Date - format = 'yyyy/mm/dd'

    Date - value = '20041308'

    Check the values and formats of the fileds in ur message type and the db table.

    praveen

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Praveen,

      Thanks!!. I tried to update the DB without the Date, its now working fine. I will use the DateTransform function, for that.

      Have a great day.

      Best Regards,

      Raj.