cancel
Showing results for 
Search instead for 
Did you mean: 

Executing Stored Procedures from JDBC adapter

Former Member
0 Kudos

Hello,

I came across a particular integration situation, XI needs to call a oracle stored procedure(still DB guys need to build), and needs to send multiple lines of data to insert into a table.

I have couple of questions:

1. Can we create a stored procedure with input as "table type" which can take multiple lines of records.

2. if above is possible then can we call this procedure from XI if so what is the syntax for the jdbc adapter?

Please let me know if any body has clues on this, you feedback is really appreciated.

Please let me know if you need any further info?

Thanks in advance..

-laxman

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi laxman,

SAP provided JDBC adapter doesn't support table input as a parameter to a stored procedure.

look at the following link for more detals

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

Cheers,

Naveen

Answers (0)