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