Use associative array in SQL

Hi,

Is it possible to use an associative array in a SQL in a procedure?

Thanks
Sam

Yes. That's a pl/sql table.
Check here http://www.oracle.com/technology/sam...har2/start.htm

Thank you PavB.

Actually I was asking if I could use associative arrays/PLSQL tables in a sql query in my package.
I couldnt, But I could use nested tables instead.

Thanks
Sam