JDBC Receiver Adapter - Call Stored Procedure

Hi,

I am using a JDBC receiver adapter to call a stored procedure in oracle.

My target structure looks like:-

<STATEMENT>

<storedProcedureName action="EXECUTE">

<table>realStoredProcedureName</table>

<serialDate hasQuot="NO" isInputType="true" type="date">TO_DATE('07-15-2008 08:00:11','MM-DD-YYYY HH24:MI:SS')</serialDate>

<serialNo isInputType="true" type="NUMERIC">123456</serialNo>

</storedProcedureName>

</STATEMENT>

The storedprocedure takes two input values and has one output value.

The first parameter of the stored procedure is serialDate and the second input parameter is serialNo.

I am getting an exception:-

<SAP:AdditionalText>com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'storedProcedureName' (structure 'STATEMENT'): java.lang.NumberFormatException: For input string: "TO_DATE('07"</SAP:AdditionalText>

Any ideas how to fix this issue.

Thanks.

Krishnan