pl sql: String into an array

[yns]

I have a string myString := "'YS','RB','AW'" which I want to put into an array

lNames := lVarray(myString);

How can I get the array to understand the values are separated by commas and not to treat this as one long string?

 

[Dagon]

You will have to break up the string in a loop using the INSTR and SUBSTR parameters, then assign the resulting substrings to the array elements. If you do a search on this forum, there have been a number of examples of using string functions in this way.

 

[yns]

Thanks. I was hoping there may be an easier way which I hadn't been able to find.

Will Do.