Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Pass a array as IN parameter to cursor

483888Aug 18 2006 — edited Aug 18 2006
Hi, ( 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 );
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 15 2006
Added on Aug 18 2006
1 comment
1,037 views