Handling Empty date value in the stored procedure call

[Former Member]

Hi,

i am executing a stored procedure having date element, getting below the error for the empty date value.

can any solve this issue?

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.text.ParseException: Unparseable date: ""

Thank You,

Madhav

[justin_santhanam]

Madhav,

Can you check if you are sending blank values to the date parameter?

raj

[Former Member]

issue is solved by changing the type parameter to VARCHAR when empty date is the input

[VijayKonam]

Try changing the date field to string in your stored procedure.

VJ