Pl/SQL: Using Variable With IN Operator

From: Tim Humphrey <zzhumphreyt_at_my-deja.com>
Date: 2000/06/07
Message-ID: <8hmgs9$m0q$1@nnrp1.deja.com>#1/1

In PL/SQL is it possible to have the following statement:

CURSOR some_cursor IS
  SELECT
    *
  FROM
    some_table
  WHERE
    some_field IN a_variable;

If so how do I declare the variable and assign values to it? I've experimented with records and nested tables with no luck. I'd rather not individually store the elements in separate variables if I don't have to. I'm on Oracle 7.3.3.4 and PL/SQL 2.3.3.4.

--

..._Tim_...
--=[It has just been discovered that research causes cancer in rats.]=--
http://www.birdnest.org/zzhumphreyt

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jun 07 2000 - 00:00:00 CDT