[ DarkMan @ 25.09.2012. 14:15 ] @
Da li je moguce za indeks kolekcije koristiti vrednost polja iz unutrasnjeg upita? Sledeca skripta nece da se izvrsi: Code: declare type ime_record is record (ime varchar2(50), pol varchar2(1)); type ime_type is table of ime_record index by pls_integer; v_imena ime_type; v_imena_max integer; v_ref sys_refcursor; v_out ime_type; begin v_imena(1).ime := 'ALEKSA'; v_imena(1).pol := 'M'; v_imena(2).ime := 'ALEKSANDAR'; v_imena(2).pol := 'M'; v_imena(3).ime := 'ALEKSANDRA'; v_imena(3).pol := 'Z'; v_imena(4).ime := 'ANA'; v_imena(4).pol := 'Z'; v_imena(5).ime := 'ANASTASIJA'; v_imena(5).pol := 'Z'; v_imena_max := v_imena.count; select v_imena(index_ime).ime, v_imena(index_ime).pol bulk collect into v_out from (select trunc(dbms_random.value(1, v_imena_max)) as index_ime from (select rownum as rnum from all_objects where rownum <= 1000)); end; vraca gresku: Code: ORA-06550: line 24, column 42: PLS-00201: identifier 'INDEX_IME' must be declared |