JDBC Receiver Stored Procedure

[Former Member]

I want to trigger a receiver stored procedure.

According to SAP Help the following should be the structure.

<StatementName5>

<storedProcedureName action=u201D EXECUTEu201D>

<table>realStoredProcedureeName</table>

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

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

</storedProcedureName >

</StatementName5>

My requirement is that i need to pass details about multiple employees to the stored procedure.

Can anybody help me out in changing the above structure?

Warm Regards,

Rahul

[Former Member]

Hi Rahul,

Praveen is Right, If you have multiple rows of data, Every row it describe the one stored procedure structure and it call to the stored procedure ,

If 100 rows, 100 times it call to the stored procedure.

Sateesh

[former_member181985]

No need to change...

<StatementName5> (this node should be 0..unbounded)

<storedProcedureName action=u201D EXECUTEu201D>

<table>realStoredProcedureeName</table>

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

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

</storedProcedureName >

</StatementName5>

For each employee replicate this structure in the mapping

[Former Member]

Praveen,

Does it mean XI is calling the stored procedure multiple times?

[former_member181985]

yes correct, Multiple SQL statements, but in one transaction...

Edited by: Praveen Gujjeti on Sep 15, 2010 12:43 PM

[Former Member]

On Stored procedure Does ur IN Parameter is with Cursor Type or record Set Type?

Only those Structure can accept More then 1 value ...in one go