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;
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
ORA-06550: line 24, column 42:
PLS-00201: identifier 'INDEX_IME' must be declared