This discussion is archived
2 Replies Latest reply: Feb 22, 2013 5:30 AM by 926318 RSS

Bulk collect and nested tables

926318 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points