Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE table_name (x) AS
SELECT * FROM DUAL;
1 rows affected

CREATE PACKAGE PACKAGE_NAME
AS
  TYPE RefCursorTyp IS REF CURSOR
    RETURN TABLE_NAME%ROWTYPE;

  PROCEDURE get_Strongly_Typed_Cursor (
    out_cursor OUT RefCursorTyp
  );
END;
/
CREATE PACKAGE BODY PACKAGE_NAME
AS
  PROCEDURE get_Strongly_Typed_Cursor (
    out_cursor OUT RefCursorTyp
  )
  IS
  BEGIN
    OPEN out_cursor FOR
     SELECT * FROM TABLE_NAME;
  END;
END;
/
DECLARE
  v_cur PACKAGE_NAME.RefCursorTyp;
  v_row PACKAGE_NAME.TABLE_NAME%ROWTYPE;
BEGIN
  PACKAGE_NAME.get_Strongly_Typed_Cursor(v_cur);
  LOOP
    FETCH v_cur INTO v_row;
    EXIT WHEN v_cur%NOTFOUND;
    DBMS_OUTPUT.PUT_LINE(v_row.x);
  END LOOP;
END;
/
ORA-06550: line 3, column 22:
PLS-00302: component 'TABLE_NAME' must be declared
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated