Can you use a variable as a name for Nested Table or an item in a Collections?

[gandolf989]

PL/SQL does not know where to find .extend, it is a method on an object not a stand alone function.

v_MyCol_n := .EXTEND;

From looking at this it isn't very clear where your data is coming from or what you are doing with it. If you really want to use a PL/SQL collection you need to define a rowtype if it is something other than a table, then you define a collection, then you select col1, col2, etc bulk collect into Then you can iterate through the collection and do what ever it is that you are trying to do. This isn't Java, you can't define a with block and have it implied that you are referencing a particular object.

IMHO, you need to explain what you are ultimately trying to accomplish.