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
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;