cancel
Showing results for 
Search instead for 
Did you mean: 

Maaping structure to use stored procedure with table type parameter in jdbc receiver

former_member192181
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

ambrish_mishra
Active Contributor
0 Kudos

Hi Lalitha,

Please check the thread SAP PI JDBC Stored Procedure Call | SCN

Hope it helps!

Ambrish

iaki_vila
Active Contributor
0 Kudos

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.

gagandeep_batra
Active Contributor
0 Kudos