Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE mytable( id VARCHAR2(1) );
BEGIN
 INSERT INTO mytable VALUES('A');
 INSERT INTO mytable VALUES('B');
END;
/
1 rows affected

CREATE OR REPLACE PROCEDURE Convert_ID(p_myrecordset IN OUT SYS_REFCURSOR) AS 
BEGIN 
  OPEN p_myrecordset FOR
    SELECT id, ASCII( id )
      FROM mytable
     ORDER BY id;    
END;
/
DECLARE
  l_cursor  SYS_REFCURSOR;
  l_value1  mytable.id%TYPE;
  l_value2  INT;
BEGIN

  Convert_ID(p_myrecordset => l_cursor);            
            
  LOOP 
    FETCH l_cursor
    INTO  l_value1, l_value2;
    EXIT WHEN l_cursor%NOTFOUND;
    DBMS_OUTPUT.PUT_LINE(l_value1 || ' - ' || l_value2 );
  END LOOP;
  CLOSE l_cursor;
END;
/
1 rows affected

dbms_output:
A - 65
B - 66