collection in where clause

Ugh, can anyone shed some light on this?

I fill in and would like to use a collection of numbers in a where clause. I get the error that indicates I don't have access to the collection.

Oracle 8.0.5

type id_table is table of number index by binary_integer;

declare zone_list id_table;

...fill in zone_list....

• now try and use it

select lane_id
  from lane
 where zone1_id in zone_list

       or zone2_id in zone_list

.....error on compile...
Received on Thu Feb 04 1999 - 13:14:10 CST