on 05-08-2006 3:15 PM
Hi all,
I want to ask you if there is a possibility to pass collections/set from SAP XI to a stored procedure via the JDBC-adapter?
best regards,
Hannes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Good day Hannes,
I guess by saying <i>collections/set</i> you mean records coming from XI in XI-xml format.
If so the answer is YES.
Using the XI JDBC adapter you can pass a record set to the databse if you follow the strickt XML structure explained in the following link for using stored proceadure with message payload coming through XI.
make sure you've configured the adapter right and the JDBC bridge matching your DB version and type.
<a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/14/80243b4a66ae0ce10000000a11402f/frameset.htm">Stored procedure with JDBC</a>
Good luck
Nimrod
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Hannes,
In the case of the receiver JDBC adapter, you can insert/ update/ delete data and execute stored prooedure into your databse.
For more info, look at these links,
http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm
http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
Also, check this blog,
/people/sriram.vasudevan3/blog/2005/02/14/calling-stored-procs-in-maxdb-using-sap-xi
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.