Using IN operators in Cursors

[Anon]

Hi All,

assume an array variable of numeric type is having multiple values.
Like a(0) = 100, a(1) = 101, a(2) = 102 etc.

Now i have to call the cursor where i have write a query to fetch records for the above values. for ex. i have to select the records from emp table for the emp_no in 100,101,102..etc.

So can i use the IN operator in a cursor like
SELECT * FROM emp WHERE emp_no IN a(i).

Kindly reply me.

Thanks,

Ibrahim.