Pass a array as IN parameter to cursor
483888Aug 18 2006 — edited Aug 18 2006Hi, ( sorry by my english ).
My question is how can I do to pass to cursos a array of values in just one varible. For example:
cursor emp (par <ARRAY> ) is
select name
from empoyees
where id in ( par );
What kind of variable do I have to pass to the cursor ?. I tried with next but doesn't work:
type vec is table of integer index by binary_integer;
vector vec;
cursor emp (par vec ) is
select name
from empoyees
where id in ( par );