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?

On Jun 14, 1:39*pm, The Magnet <a... (AT) unsu (DOT) com> wrote:
That's out of my experience, but a quick google says you can according
to Steven Feuerstein and http://tonguc.wordpress.com/2007/02/...ctices-part-2/

Didn't notice any actual examples though.

Does it give you an error?

jg
--
@home.com is bogus.
http://www.signonsandiego.com/news/2...ndparent-scam/

On Jun 15, 4:09*pm, joel garry <joel-ga... (AT) home (DOT) com> wrote:
Did not really get a working version going. But I'll check the site
and if he says it can be done, then it is only a matter of trial and
error until it works......