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

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