on 11-23-2009 12:56 PM
Dear All,
I have a requirement, where i have to call a stored procedure through reciever JDBC adapter by providing multiple records at a time as input to the stored procedure, and also recieve multiple records at a time.
Can any one tell me, how the structure of data type should be, to provide multiple input to the stored procedure.
Please reply soon.
Thanks in Advance.
Regards,
Zafar Ali
Make the occurance of <access> tag as 0..unbounded so that you can send multiple records in a single call.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The way to call a stored procedure is given in this blog: /people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures
Also help has a mention of the same: http://help.sap.com/saphelp_nw70/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
See StatementName5
You can even search on SDN for more blogs/ tips on how-to with stored procedure.
Regards,
Abhishek.
For stored procedure the data type should be designed as mentioned in documentaion for JDBC formats-
http://help.sap.com/saphelp_nw70/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
Make the occurance of Statement tag as 0..unbounded to send multiple records in a single message.But each record will inturn call stored procedure.
Sending multiple records in a single call seems to have restrictions-
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
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.