Solved it. Ended up being pretty straightforward. Need to do the OFFSET x ROWS FETCH NEXT y ROWS ONLY in an inline view.

DECLARE
  l_hits SYS_REFCURSOR;
BEGIN 
  OPEN l_hits for
    SELECT CURSOR(SELECT *
                    FROM emp) hits
      FROM (SELECT * 
              FROM dept
             ORDER BY deptno
            OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY) dept;
END;

Hopefully it is useful for others in the future.