Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE employees(id, name) AS
SELECT 1, 'Alice' FROM DUAL UNION ALL
SELECT 2, 'Beryl' FROM DUAL UNION ALL
SELECT 3, 'Carol' FROM DUAL;
3 rows affected

create or replace procedure getempdata(
  v_id in number,
  q out sys_refcursor
)
as
begin
  open q for select * from employees where id = v_id;
end;
/
DECLARE
  v_cur SYS_REFCURSOR;
  v_row EMPLOYEES%ROWTYPE;
BEGIN
  -- call the procedure
  getempdata(1, v_cur);

  -- read the rows
  LOOP
    FETCH v_cur INTO v_row;
    EXIT WHEN v_cur%NOTFOUND;
    DBMS_OUTPUT.PUT_LINE(v_row.id);
  END LOOP;
  
  -- close the cursor
  CLOSE v_cur;
EXCEPTION
  WHEN OTHERS THEN -- Handling OTHERS is bad practice, normally you should be more specific
    IF v_cur%ISOPEN THEN
      CLOSE v_cur;
    END IF;
END;
/
1 rows affected

dbms_output:
1

SELECT * FROM USER_ERRORS;
BEGIN
  test_proc(42, days_nt('1', '7'));
END;
/
ORA-06550: line 2, column 17:
PLS-00201: identifier 'DAYS_NT' must be declared
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored

Select *
from   demo
where  test in (1, 7);
ORA-00942: table or view does not exist