JDBC Receiver Adapter Error

[Former Member]

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 · Accepted solution]

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

[Former Member · Accepted solution]

Hi Sateesh,

SP_CREATE_T_BATCH is the Stored procedure name

this SP is having one inparameter and one out parameter of NUMBER type.

IN_Control_Recipe is the input parameter name

Edited by: Rams on Oct 6, 2010 6:46 AM

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hi Ram,

Since you mentioned that your SP has one input parameter and one output parameter, the structure of the XML message at the JDBC receiver side should be:

<STATEMENT2>

<SP_CREATE_T_BATCH action="EXECUTE">

<IN_Control_Recipe isInput="true" hasQuot="No" type="BIGINT">100000000001723850</IN_Control_Recipe>

<Output_Parameter isOutput="true" type="SQLDataType"></Output_Parameter>

</SP_CREATE_T_BATCH>

</STATEMENT2>

Here, i have assumed the following:

SP_CREATE_T_BATCH - The name of the Stored Procedure to be executed

IN_Control_Recipe - Input parameter of the SP and its SQLDataType is BIGINT as suggested by Stefan.

Output_Parameter - Output parameter of the SP. You may enter the SQL data type as per the output of your Stored Procedure.

The following SQL data types are supported:

INTEGER, BIT, TINYINT, SMALLINT, BIGINT, FLOAT, REAL, DOUBLE, NUMERIC, DECIMAL, CHAR, VARCHAR, STRING, LONGVARCHAR, DATE, TIME, TIMESTAMP, BINARY, VARBINARY, LONGVARBINARY, BLOB (input and output),CLOB (input and output), CURSOR (output; only in conjunction with the Oracle JDBC driver).

Hope this will surely solve your problem.

Regards, Gaurav.

[Former Member · Accepted solution]

strctured defined properly now

[stefan_grube]

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

[Former Member]

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

[Former Member]

Hi I have Given isInput-"TRUE" but the problem is same

[Former Member]

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