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