BULK Insert in 10gR2 database
I am trying to use BUlk insert and getting errors.
DECLARE
TYPE my_rec_tab IS TABLE OF my_table%ROWTYPE INDEX BY BINARY_INTEGER;
my_rec my_rec_tab;
CURSOR get_data
IS
SELECT * FROM MY_TABLE;
BEGIN
OPEN get_data;
FETCH get_data BULK COLLECT INTO my_rec;
CLOSE get_data;
DELETE FROM MY_TABLE;
COMMIT;
FORALL I IN my_rec.FIRST..my_rec.LAST
INSERT INTO MY_TABLE VALUES(my_rec(i));
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.PUT_LINE(SQLERRM);
END;
------------/*
When i run this block it says error PLS -009407 not enough values. Can anyone help