DECLARE

    cursor c_data is

    select * from audit_wa
    where ticket = '0000000000000000000000000000001';

    BEGIN

    for i in c_data loop

    DBMS_OUTPUT.PUT_LINE('ID: ' || i.id);

    END LOOP;

    EXCEPTION
       
       WHEN NO_DATA_FOUND
       THEN
          DBMS_OUTPUT.put_line ('Ticket does not exist');
    END;

    DECLARE

    cursor c_data is

    select * from wa_audit
    where ticket = 'INC000003154946';
    
    V_ERROR   EXCEPTION;
    v_data    c_data%rowtype;

    BEGIN
    OPEN c_data;
    
    LOOP
            FETCH c_data into v_data;
            
            IF (c_data%rowcount > 0) THEN
        
            EXIT WHEN c_data%notfound;
            DBMS_OUTPUT.put_line ('ID: ' || v_data.id);
             
            ELSE
            
            RAISE V_ERROR;
            
            END IF;
    END LOOP;

    

    EXCEPTION
       
       WHEN V_ERROR
       THEN
          DBMS_OUTPUT.put_line ('It does not exist');
          
         
          
    END;

DECLARE 
    CURSOR c_data IS 
      SELECT * 
      FROM   wa_audit 
      WHERE  ticket = 'INC000003154946'; 
    v_data c_data%ROWTYPE; 
BEGIN 
    OPEN c_data; 

    LOOP 
        FETCH c_data INTO v_data; 

        IF ( c_data%rowcount > 0 ) THEN 
          EXIT WHEN c_data%NOTFOUND; 

          dbms_output.Put_line ('ID: ' 
                                || v_data.id); 
        ELSE 
          dbms_output.Put_line ('It does not exist'); 
        END IF; 
    END LOOP; 
END; 

SQL> declare curs sys_refcursor; rec emp%rowtype;
  2  begin
  3    open curs for select * from emp;
  4    loop
  5      fetch curs into rec;
  6      exit when curs%notfound;
  7    end loop;
  8    dbms_output.put_line('Rowcount is: '||curs%rowcount);
  9    close curs;
 10  end;
 11  /
Rowcount is: 14

PL/SQL procedure successfully completed.