923315 wrote:Correct. PL/SQL will re-initialize it and extend it. And re-initializing means you will lose all prior collection content. There is no option to bulk collect append (too bad).
so can you please confirm that these is no need to initialize and extend when we use bulk collect and nested table?
but i have seen that when we use bulk insert we need to initialize constructor and use the extend functionality.Not sure what you're talking about. Bulk insert (i.e. FORALL) reads from a nested table, it has nothing to do with getting data into one.