If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

perhaps you should refrain from using constructs that you don't know how to control & manipulate.

While nested objects may seem "elegant" they bring no added value to the application solution.

KISS!

You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.

create a string with all the values (comma separated), replace in the string the commas by ' comma ' and after that make an execute immediate for the command in a string concatenated with the values string.

Thanks, xixo, I'm sure it will be. But the best advice as others have already said is not to use nested tables in the first place! Unfortunately, since they exist and are newer than vanilla relational tables, people tend to assume they must be a Good Thing, and Oracle training courses spend a day showing you how to use them (another day, another $400!) so newbies end up using them.

More experienced Oracle users avoid them, not because we are Luddites, but because we find that they (a) add no value, and (b) add pain and misery.