2010년 6월 9일 수요일

How to append oracle user collection type...

create or replace
TYPE "VARCHAR_ARRAY" AS TABLE OF VARCHAR2(200);

create or replace
TYPE "MULDIM_ARR" is table of varchar_array ;

aItemArray MULDIM_ARR := MULDIM_ARR();

-- loop clause
aItemArray.EXTEND;
aItemArray(i) := VARCHAR_ARRAY(aSubArray(1), 'A', aSubArray(2));
-- loop end