PL/SQL: Cursors with Parameters

PROCEDURE example

  CURSOR emp_cur (emp_id_in NUMBER := 0) IS
    SELECT employee_id, emp_name
     FROM employee
     WHERE employee_id = emp_id_in;

BEGIN

  OPEN emp_cur (1001);

END example;