Bulk Insert

From: The Magnet <art_at_unsu.com>
Date: Tue, 14 Jun 2011 13:39:07 -0700 (PDT)
Message-ID: <193851d0-b74c-4c89-a343-1d18c7f140df_at_s9g2000yqm.googlegroups.com>

There is no real documentation that I can find on this, so here goes the question. Can I combine a FORALL ... INSERT with a nested table?

Say I have this code:

  OPEN ticker_detail;
  FETCH ticker_detail BULK COLLECT INTO v_read_record;   CLOSE ticker_detail;
.
.
.

  FORALL y IN v_read_record.FIRST .. v_read_record.LAST     INSERT INTO stock_info_snapshot VALUES v_read_record(y);

If stock_info_snapshot contains a nested table, can this or will this work? Received on Tue Jun 14 2011 - 15:39:07 CDT