How to pass values to Struct input type a JDBC adapter service.


I need to pass input to an oracle pl/sql stored procedure whose input parameter is of type STRUCT.

The data that I have in hand is in the below format.



The stored procedure is expecting the data in the below format:
—upto n items details

I can concatenate all the tags in the input xml for each item into a single string and form a string list.

I created JDBC adapter services with stored procedure template and stored procedure with signature template. The input param to the adap service is an object (as the stored proc is expecting a struct type).

Now how do I pass the concatenated input to the adapter service?

WM 7.1
JDBC adap: 6.5
Please help. Let me know if I need to share any other info. A little urgent.

Best regards,