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?
JDBC adap: 6.5
Please help. Let me know if I need to share any other info. A little urgent.