How to do BULK INSERT using FORALL
WilhelmAug 30 2007 — edited Aug 30 2007I have some values being held in several assosiative arrays. I want this to be INSERTed to table emp_dtl. Lets say one of those assosiative array is v_enum
I want values in v_enum variable to be INSERTed to emp_dtl table. Can anyone show me the syntax for FORALL to do the INSERTs
DECLARE
TYPE v_enum_type IS TABLE OF VARCHAR2(10) INDEX BY PLS_INTEGER;
v_enum v_enum_type;
BEGIN
.
.
.
FORALL indx IN v_enum.FIRST .. names.LAST
INSERT INTO emp_dtl ....
This gave me error. Any thoughts?
Message was edited by:
Wilhelm