Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

JDBC Receiver Adapter Error

Hi All,

I am executing SP by using JDBC Receiver Adapter.

My strcture is follows

<STATEMENT2>

<SP_CREATE_T_BATCH action="EXECUTE">

<spName type="VARCHAR">SP_CREATE_T_BATCH</spName>

<IN_Control_Recipe hasQuot="No" type="Integer">100000000001723850</IN_Control_Recipe>

</SP_CREATE_T_BATCH>

</STATEMENT2>

The below error I am getting

Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SP_CREATE_T_BATCH' (structure 'STATEMENT2'): java.lang.NumberFormatException: For input string: "100000000001723850"

Any help on this

Former Member
Former Member replied

Hi Ram,

Good to hear, So please find the below structure ,Because your stored procedure have only one Input paramter "IN_Control_Recipe".

<STATEMENT2>
 <SP_CREATE_T_BATCH action="EXECUTE">
    <IN_Control_Recipe hasQuot="No" type="Integer">100000000001723850</IN_Control_Recipe>
 </SP_CREATE_T_BATCH>
</STATEMENT2>

Please check the above structure, Hope your issue is solved.

Thank you

Sateesh

Edited by: sateesh kumar .N on Oct 6, 2010 7:03 AM

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question