on 05-20-2011 1:47 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>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
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
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.