on 10-15-2005 9:10 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.