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 !!!