u hav to first create a type in PL/SQL via SQL*Plus like this: create or replace type NUM_ARRAY as table of number; then hav to use it in the function/proc like this: create or replace function getStack(bbid_array in num_array) Morever visit this URL web page