Skip to Content
0
Former Member
Mar 12, 2010 at 09:39 AM

DateTime format in stored procedure

59 Views

Hi All,

Very Good Afternoon.

I am getting one error when i call the stored procedure from XI.

My date format is coming from Source end is for ex:2009-01-07.10:05:55.0

In My mapping i mapped to "DATE" constant to "TYPE" field. i am getting the below error in Communication channel

**************

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'XI_DATA' (structure 'StatmentName'): java.lang.NumberFormatException: For input string: "07 10:05:55.0"

**************

How i can able to solve this issue.

Thank you very much.

Sateesh