cancel
Showing results for 
Search instead for 
Did you mean: 

Passing collections/sets to a stored procedure

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

moorthy
Active Contributor
0 Kudos

Hannes~

Check this thread also-

Thanks,

Moorthy

former_member187587
Contributor
0 Kudos

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

bhavesh_kantilal
Active Contributor
0 Kudos

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