Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 06, 2010 at 04:42 AM

    Hi Ram,

    Please confirm

    is their any parameter for your stored procedure name? like below element.

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

    and please check below structure is you correctly created?

    <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>

    And please check your stored procedure Input parameters

    Thank you,

    Sateesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 06, 2010 at 03:30 AM

    now i have chaged the strcture as follows

    <STATEMENT2>

    <SP_CREATE_T_BATCH action="EXECUTE">

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

    <IN_Control_Recipe type="BIGINT">100000000001723850</IN_Control_Recipe>

    </SP_CREATE_T_BATCH>

    </STATEMENT2>

    Now I am getting the below error

    Error processing request in sax parser: Error when executing statement for table/stored proc. 'SP_CREATE_T_BATCH' (structure 'STATEMENT2'): java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at line 1

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 06, 2010 at 04:26 AM

    Hi Ram,

    in your structure you missed the "isInput" param.So please check corrected below structure.

    <STATEMENT2>
    <SP_CREATE_T_BATCH action="EXECUTE">
    <spName isInput= "TRUE" type="VARCHAR">SP_CREATE_T_BATCH</spName>
    <IN_Control_Recipe hasQuot="No" type="Integer">100000000001723850</IN_Control_Recipe>
    </SP_CREATE_T_BATCH>
    </STATEMENT2>

    thank you

    sateesh

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 06, 2010 at 01:27 PM

    > Error when executing statement for table/stored proc. 'SP_CREATE_T_BATCH' (structure 'STATEMENT2'): java.lang.NumberFormatException: For input string: "100000000001723850"*

    Integers are values up to 2147483647. You cannot use higher values.

    Add comment
    10|10000 characters needed characters exceeded