"In" Operator and Arrays

[MRWA]

Hi,

How can i use an Array or Nested Table in an IN Operator like:

Example: Package

Type T_StringArray is Table of Varchar2(20) index by binary_integer;
or:
Type T_StringArray is Varray(50) of Varchar2(20);

procedure P_ProbeArray(Arr in T_StringArray) is
NR Varchar2(20);
Begin

Select Count(CUST_PAY) Into NR From CUSTOMER Where CUST_NAME in (ARRAY);


Thanks for Supporting me !!!

[Highlander]

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;