Re: Using BULK BIND.....

From: Miggins <mtproc_at_yahoo.co.uk>
Date: 24 Feb 2006 08:39:55 -0800
Message-ID: <1140799195.251770.253430@u72g2000cwu.googlegroups.com>

Am trying this method but am getting an error on the FORALL statement....reading the documentation it looks like you can only use collections and not tables of records.

TYPE t_rec IS RECORD (field1     DATE,
                                     field2     VARCHAR2(3),
                                     field2     VARCHAR2(10))
v_rec      t_rec;

TYPE t_tab IS TABLE OF v_rec INDEX BY BINARY INTEGER; v_tab t_tab;

This table then populated by many rows to be then processed by FORALL to insert into my database table later.

FORALL i IN v_tab.FIRST .. v_tab.LAST
INSERT INTO mytable (myfield1, myfield2, myfield3) VALUES v_tab(i).field1. v_tab(i).field2. v_tab(i).field3;

PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records

Am i right in thinking this isnt possibe....each field needs to be placed in its own collection. Received on Fri Feb 24 2006 - 10:39:55 CST