on 11-29-2013 11:16 AM
Hi All,
I have a stored procedure in oracle with input parameter as Table type like proc_test_name(p_emp emp%rowtype)
how to use this procedure in maaping.
Could all please help me out in mapping strucutres
Thanks
Lalitha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Lalitha,
I havent tried to work with stored procedure tables and the jdbc adapter yet. But you could check this thread: XI/PI: jdbc receiver using stored procedure with arrays
Arkesh Sharma shows a solution inside mapping step in his blog: SAP PI - UDF to capture multiple result sets from a Stored Procedure in DB
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Devi,
Plz find below help doc for that:
http://help.sap.com/saphelp_nwpi71/helpdata/en/4d/8c103e05df2e4b95cbcc68fed61705/content.htm
regards
Gagan
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.