problem in executing SP using reciver JDBC adapter

[Former Member]

Hi all,

when i am execting a SP using Reciever JDBC adapter i am getting the below error,

com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'WD_WRAP_PROCESS_APPMT_REQ_PR' (structure 'STATEMENT'): java.lang.IllegalArgumentException

i guess this error is because of DATE field that i am using in the SP. can any one give me the solution how to handle DATE field.

Thank You,

Madhav

[Former Member]

it is solved, by giving the input type as DATE and date format in communication channel

[former_member181985]

Try this format: YYYY-MM-DD

you can give a trial and error with other date formats. Better ask DB guy what format they are expecting.

[RameshGulipall]

HI Madhav,

you check the below weblog for data and time issue with DB.

http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3417500)ID0760453250DB00677869991075830602End...

hope it will use for issue.

Regards,

Ramesh