2 Replies Latest reply: Feb 22, 2013 7:30 AM by 926318 RSS

    Bulk collect and nested tables

    926318
      Hello,
      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.

      regards,
      Prashant