on 09-15-2010 4:15 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.