How to pass a cursor as IN parameter to a procedure
796062Sep 6 2010 — edited Sep 6 2010Hello
I want to pass a cursor to a procedure as IN parameter.
See the below piece of code:
Cursor mycur is select * from table_name;
Procedure myproc(mycur IN ...)
begin
fetch mycur into v_rec;
......
....
{want to do some updates here}
end;
Please suggest how can I pass the cursor?
Thanks in advance !!!!