Oracle: Is it possible to pass a parameter to a cursor?

Answer 1

Explicit cursors can take parameters, as the example below shows. A cursor parameter can appear in a query wherever a constant can appear.
Example:
CURSOR c1 (median IN NUMBER) IS
SELECT job, ename FROM emp WHERE sal > median;