Receiver JDBC Adapter with StoredProcedure (Multiple Record)

[Former Member]

If we have to call the stored procedure in JDBC receiver adapter, how can we pass the multiple parameter. I have the incoming message as follows

<product1>

<Price1>

<Price2>

</product1>

<product2>

<Price1>

<Price2>

</product2>

How can we pass the whole thing in Stored Procedure using JDBC Receiver adapter. Any pointer will be helpful.

Thanks,

Samir

[Former Member]

More specifically it is nested structure like below

<Product>

<Product ID>97XJ</ProductID>

<Product Number>233</ProductNumber>

<Price>

<PriceID>23334</PriceID>

<PriceType>Float</PriceType>

</Price>

<Price>

<PriceID>23334</PriceID>

<PriceType>Fixed</PriceType>

</Price>

</Product>

<Product ID>49HDJ</ProductID>

<Product Number>233</ProductNumber>

<Price>

<PriceID>23334</PriceID>

<PriceType>Float</PriceType>

</Price>

<Price>

<PriceID>23334</PriceID>

<PriceType>Fixed</PriceType>

</Price>

</Product>

Please refer the first message for question.

[Former Member]

Use the following structure as an example and put as many different parameters as you want....

<StatementName5>
<storedProcedureName action=u201D EXECUTEu201D>
    		<table>realStoredProcedureeName</table>
<param1 [isInput=u201Dtrueu201D] [isOutput=true] type=SQLDatatype>val1</param1>
</storedProcedureName >  
  </StatementName5>

[Former Member]

I really liked these useful links.

From my best of best...links

JDBC 2 JDBC

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/jdbcTOJDBC

using stored procedures

[Former Member]

I think I got your problem. Can you tell exactly what you are looking for?

Input Output ??

<product1>

<product2>

Here is another link

http://help.sap.com/saphelp_nw70/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm