I have a function which will take input a ref cursor and after some internal comparison it will give output a number. My SQL Developer version is 4.0.2.
Below is the function and the output.
FUNCTION func1(input1 IN t_cursor
) RETURN NUMBER
l_ret NUMBER := 0;
FETCH p_pf INTO l_id, l_name, l_status, l_step_cnt, l_templ_cnt, l_br_cnt;
You can NOT FETCH a cursor that doesn't even exist. The parameter name is 'input1' but you try to fetch something named 'p_pf' which isn't even defined anywhere.
That can't possibly work.
I have changed the cref cursor name, but still it is throwing the same error.