RE: How to do a bulk bind to load data into a table

2002-02-14 Thread Oberkofler, Dieter
Title: RE: How to do a bulk bind to load data into a table from my understanding the FORALL statement only helps you when processing data in collections or with BULK when retrieving rows into collections. the bulk bind functionality is btw only available starting with 9i. you might want to

RE: How to do a bulk bind to load data into a table

2002-02-14 Thread Jamadagni, Rajendra
You can do it in 8i as well ... CREATE OR REPLACE PACKAGE BODY Admin_Index AS -- -- Define types TYPE itt_OWNER IS TABLE OF NCS_INDEX_STATS.owner%TYPE INDEX BY BINARY_INTEGER; TYPE itt_NAME IS TABLE OF NCS_INDEX_STATS.name%TYPE INDEX BY BINARY_INTEGER;