Hello Everybody,
I have a below mentioned data which will be passed as a XML string in the below format from the client (Form) side as a CLOB:
<row>
<portfolio_id>100</portfolio_id>
</row>
<row>
<portfolio_id>200</portfolio_id>
</row>
<row>
<portfolio_id>300</portfolio_id>
</row>
In the database side, I have to make a procedure which will accept the above XML string, which is a CLOB, and also the order_id (10), and it will insert the data in the order_portfolio table as mentioned below.
order_id portfolio_id
10 100
10 200
10 300
Now my query is how do I convert/extract the above xml into a relational data and insert into the order_portfolio table.
Looking forward to your feedback.
Thank you all for your kind co-operation,
MAK