cancel
Showing results for 
Search instead for 
Did you mean: 

Problem in updating DataBase Table

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

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.