Hi I have a function that has a CLOB input. The input value is concatenated of multiple values. I need to separate them and process the data. Below is the sample function example. Can any one please help me on this. I'm not able to get any solution.
l_orders CLOB Chennai|$| Mumbai |$| Delhi |$| Amsterdam |$| brazil |$| ......... |$| Hyderabad
Now I need to get the values like below into a collection
l_orders(1) chennai
l_orders(2) Mumbai
l_orders(3) Delhi
l_orders(4)Amsterdam
l_orders(5) Brazil
.
.
.
.
l_orders(6000) Hyderabad
These values I need to pass into the table and do a DML operation based on some conditions. I'm helpless on how to take the input CLOB into a collection.
I use oracle version 11g.