Receiver JDBC Stored Procedure XML structure

[Former Member]

I have the following scenario IDOC to JDBC. The receiver table has 6 fields f1 , f2 ,f3 ,f4 , f5 , f6 . There is a stored procedure sp_test created to populate the table to be executed from PI.

Can someone please let me know the correct xml structure to map the IDOC to target structure?

Thank you,

Hari

Edited by: Hari Krishna on Jun 29, 2011 5:37 PM

[baskar_gopalakrishnan2]

ref this [link |http://help.sap.com/saphelp_nw70/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm]

and create target structure similar to below....

<Statement>

<storedProcedureName action=u201D EXECUTEu201D>

    <table>ProcedureName</table>

<param1 [isInput=u201Dtrueu201D] [isOutput=true] type=SQLDatatype>val1</param1>

</storedProcedureName >  

  </Statement>

[Former Member]

Thank you Gopal. In my case I am inserting the fields into the sql table so all the fields will be an output parameter with isOutput = 1 correct?

[baskar_gopalakrishnan2]

You need to verify. I believe input parameter what we pass for insert and output for select fields. So input might be for insert.

The elements within the stored procedure are interpreted as parameters. They can optionally have the attribute isInput=u201C1u201C (input parameter) or isOutput=u201C1u201C (output parameter) or both (INOUT parameter).

Edited by: Baskar Gopal on Jun 29, 2011 12:28 PM

[Former Member]

Thanks I will check and update this thead later.

Regards,

Hari

Edited by: Hari Krishna on Jun 29, 2011 8:00 PM

[Shabarish_Nair]

this shows you the use of SP - /people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures