2 Replies Latest reply on Feb 22, 2013 1:30 PM by 926318

    Bulk collect and nested tables

      i have some queries regarding bulk collect and nested table.
      Normally whenever we use nested tables in pl/sql programming we have to first initialize the constructor and then before assigning any value in the nested table we need to use extend.
      but during bulk collect i have seen ( also used ) in many programs that ,we dont initialize the constructor and dont use extend.
      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.

      thanks in advance.