SAP PI JDBC Stored Procedure Call

[Former Member]

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

[Former Member · Accepted solution]

Make the occurance of <access> tag as 0..unbounded so that you can send multiple records in a single call.

[Former Member · Accepted solution]

Hi Nagarjuna,

Thanks for early response.

My requirement is to call Stored procedure in Oracle 10g. Please response weather we can add <Access> tag while calling Stored Procedure. If not please suggest me how to pass multiiple records to Stored Procedure in a single call.

Regards,

Zafar Ali

[former_member200962 · Accepted solution]

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.

[Former Member · Accepted solution]

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-