Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> [oracle-l] FW: pl/sql array processing?
My following message did not seem to make it to oracle-l.freelists. Let me
try it again.
Guang
I have the folliwng pl/sql code for oracle 8173. I am wondering if there is a way to make it faster by not looping each array elements, but doing some kind of "forall" opration to my_package.function?
declare
type numTbl is table of number index by binary_integer;
refTbl numTbl; i number; str varchar2(30);
refTbl (1) := 1; refTbl (9) := 1; refTbl(15) := 1; refTbl(99) := 1;
i := refTbl.first;
while i is not null loop
dbms_output.put_line ('i=' || i);
str:= my_package.function(i);
i := refTbl.next(i);
end loop;
end;
/
TIA. Guang
![]() |
![]() |