Question about PL/SQL tables

From: Haresh Assumal <assumal_at_sprynet.com>
Date: 1997/11/18
Message-ID: <01bcf467$b95697c0$fab1aacc@mycomp.intermediainc.com>#1/1

Hello,
Can I use a PL/SQL table within a SQL statment in a PL/SQL function in Oracle8?

Assume I have a table defined as:
create table company(id number, name varchar2(32))

I need to open a cursor from a PL/SQL procedure as follows:

	open pCur for
		select name from company where
		id IN <A PL/SQL table of ints>

Where pCur is of type ref cursor. Is this possible? Would the operator IN work with a pl/sql table? How do I create the function? Your help would be much appreciated.
Thanks,
Haresh Received on Tue Nov 18 1997 - 00:00:00 CST