DateTime format in stored procedure

[Former Member]

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

[Former Member · Accepted solution]

Hi Sateesh,

The error says numbe format exception at 07 10:05:55.0. If the field allows only numbers then I see a space and colon. So check with your database guys what the column is exactly expecting and how they defined in the table.

The datatimeformat depends on the database you use. Please see some formats for oracle and sql here. Use accordingly.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements004.htm#SQLRF00210

http://technet.microsoft.com/en-us/library/ms187819.aspx

Regards,

---Satish

[VijayKonam]

Ask your SQL counter parts to tell you the date format they are expecting. Or a simple google would work.

VJ