Calling Stored procedures using SAP XI

[Former Member]

Hello Experts,

I have an requirement wherein idoc is posted from SAP to XI and receiver side we have Oracle system.

My requirement is that can we call stored procedures residing at oracle system using SAP XI.

Please advise how and wat all configuration needs to be maintained in XI.

Thanks

[former_member463616 · Accepted solution]

Hi,

>>Please advise how and what all configuration needs to be maintained in XI.

Please see the below link, it might be helpful to you.

/people/sriram.vasudevan3/blog/2005/02/14/calling-stored-procs-in-maxdb-using-sap-xi

Regards,

P.Rajesh

[former_member181962]

Check this link:

http://help.sap.com/saphelp_nw70/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Look at statement 5.

also look at the following blog:

/people/luis.melgar/blog/2008/05/13/synchronous-soap-to-jdbc--end-to-end-walkthrough

Best Regards,

ravi

[Former Member]

Hi,

I have gone through Blog which u had mentioned.But my requirement is

My Receiver JBDC Structure is multi hierarchial..ie there are many levels of nodes..So is it possible to send entire nested structure using Stored Procedure call..

Can u please let me know the way to do these.

[baskar_gopalakrishnan2]

>My Receiver JBDC Structure is multi hierarchial..ie there are many levels of nodes..So is it possible to send entire nested structure using Stored Procedure call..

What do you mean by multi hierarchial? Follow the jdbc structure as SAP recommends. You cannot create your own jdbc structure. If your data goes to different table in the database then create multiple Statment each refering to seperate table.

<Statement1>

>>> for table1 insert

</Statement1>

<Statement2>

>>>> for table 2 update

</Statement2>

like this. Please follow the sap help link.

http://help.sap.com/saphelp_nw70/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm