Can we pass parameters to a cursor as functions ? If yes then please give me an example. Thank you in advance.
Yes, you can.
Define cursor as:
CURSOR c_cur(i_param number) IS SELECT a, b, c, d FROM table WHERE e = i_param;
OPEN c_cur(12345); FETCH ...
The rules are the same as parameters in functions and procedures.
No one has followed this question yet.