Skip to Content
avatar image
Former Member

problem in executing SP using reciver JDBC adapter

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Mar 16, 2010 at 09:36 AM

    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?blog=/pub/wlg/2002

    hope it will use for issue.

    Regards,

    Ramesh

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 16, 2010 at 09:36 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 24, 2010 at 06:10 PM

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

    Add comment
    10|10000 characters needed characters exceeded