Hi,
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.
1234-T
<REQ_DATE>30-MAR-2011</REQ_DATE>
<REQ_QTY>5</REQ_QTY>
1235-T
<REQ_DATE>10-APR-2011</REQ_DATE>
<REQ_QTY>4</REQ_QTY>
The stored procedure is expecting the data in the below format:
1234-T|30-MAR-2011|5
1235-T|10-APR-2011|4
—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,
KRV