procedure P_ProbeArray(Arr in T_StringArray) is
NR Varchar2(20);
CURSOR c1(var varchar2) is SELECT COUNT(cust_pay) ccount
FROM CUSTOMER
WHERE cust_name = var;
Begin
for I .. arr.count
loop
for cc1 in c1(arr(i))
loop
NR = cc1.ccount;
end loop;
end loop;
end;




Reply With Quote