Passing array ( table ) in the where clause

From: <secindia_at_hotmail.com>
Date: 1997/11/14
Message-ID: <879524835.5465_at_dejanews.com>#1/1


I need to pass a table ( array ) in the where clause of the SQL select statement. Get an error. I can successfully pass a subscript not not the

whole array. Some what on these lines. /* code list */ Declare	Type
t_tst is table of varchar2(30)		   index by binary_integer;	 
 aaa t_tst ;	 sala number;

Begin
	aaa(1) := 'SMITH';
	aaa(2) := 'JONES';
	Select sal into sala from emp Where ename in aaa;
End;
/

Help welcome.
RBS

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Fri Nov 14 1997 - 00:00:00 CET

Original text of this message