ORA-01410: invalid ROWID
ORA-06512: at "CUST_MAIL_UPDATE", line 217
ORA-06512: at line 38

  -- declare some object structures to hold the retrieved data
  TYPE driver_rec IS RECORD (
    account_no         ext_driver.account_no%TYPE,
    update_action      ext_driver.update_action%TYPE,
    customers_rowid    ext_driver.customers_rowid%TYPE);

  TYPE driver_recs_tt IS TABLE OF driver_rec;

  -- cursor to get the records from the driver table
  CURSOR cur_get_driver_recs IS
   SELECT account_no,
          update_action,
          customers_rowid
     FROM ext_driver
    WHERE processed = 'N'
      FOR UPDATE OF processed;

  driver_records  driver_recs_tt;

  error_count NUMBER;
  CUST_BULK_UPDATE_FAIL EXCEPTION;
  PRAGMA EXCEPTION_INIT(CUST_BULK_UPDATE_FAIL, -24381);

BEGIN

  -- get the records from the driver table
  OPEN cur_get_driver_recs;
  LOOP
    -- process the records using Bulk Collections.
    FETCH cur_get_driver_recs BULK COLLECT INTO driver_records LIMIT 1000;

    FORALL i IN 1..driver_records.COUNT SAVE EXCEPTIONS

    UPDATE customers c
       SET mailing_option = driver_records(i).update_action
     WHERE c.rowid = driver_records(i).customers_rowid;

--    UPDATE ext_driver
--       SET processed = 'Y'
--     WHERE CURRENT OF cur_get_driver_recs;

    EXIT WHEN cur_get_driver_recs%NOTFOUND;

  END LOOP;

  COMMIT;

  EXCEPTION
    WHEN CUST_BULK_UPDATE_FAIL THEN
     error_count := SQL%BULK_EXCEPTIONS.COUNT;
     DBMS_OUTPUT.PUT_LINE('Number of updates that failed: ' || error_count);
     FOR i IN 1..error_count LOOP
        DBMS_OUTPUT.PUT_LINE('Error #' || i || ' occurred during '||
           'iteration #' || SQL%BULK_EXCEPTIONS(i).ERROR_INDEX);
            DBMS_OUTPUT.PUT_LINE('Error message is ' ||
            SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE));
     END LOOP;
END;

  OPEN cur_get_driver_recs;
  LOOP
    -- process the records using Bulk Collections.
    FETCH cur_get_driver_recs BULK COLLECT INTO driver_records LIMIT 1000;

    FORALL i IN 1..driver_records.COUNT SAVE EXCEPTIONS

  OPEN cur_get_driver_recs;
  LOOP
    FETCH cur_get_driver_recs BULK COLLECT INTO driver_records LIMIT 1000;
    EXIT WHEN driver_records.COUNT = 0;

    -- we have multiple DML statements so cannot use FORALL, instead use FOR LOOP
    FOR i IN 1..driver_records.COUNT
    LOOP  

  TYPE driver_rec IS RECORD (
    account_no         ext_driver.account_no%TYPE,
    update_action      ext_driver.update_action%TYPE,
    customers_rowid    ext_driver.customers_rowid%TYPE,
    driver_rowid       ext_driver.customers_rowid%TYPE);
    
  TYPE driver_recs_tt IS TABLE OF driver_rec;

  -- cursor to get the records from the driver table
  CURSOR cur_get_driver_recs IS
   SELECT account_no,
          update_action,
          customers_rowid,
          ROWID driver_rowid
     FROM ext_driver
    WHERE processed = 'N'
    
  driver_records  driver_recs_tt;    

BEGIN
  
  OPEN cur_get_driver_recs;
  LOOP
    FETCH cur_get_driver_recs BULK COLLECT INTO driver_records LIMIT 1000;
    EXIT WHEN driver_records.COUNT = 0;

    -- we have multiple DML statements so cannot use FORALL, instead use FOR LOOP
    FOR i IN 1..driver_records.COUNT
    LOOP  
 
      BEGIN
        UPDATE customers c
           SET mailing_option = driver_records(i).update_action
         WHERE a.rowid = driver_records(i).customers_rowid;
  
        -- now update the driver table
        UPDATE driver_table
           SET processed = 'Y'
         WHERE ROWID = driver_records(i).driver_rowid;

      EXCEPTION
        -- if either update fails then we get here. Result is no update to driver
        -- table and record will be processed the next time.
      WHEN OTHERS THEN
         dbms_output.put_line('Update failed for Acct: ' || driver_records(i).account_num ||
                              ' with Error: ' || SQLCODE || ' (' || SQLERRM || ')');
      END;
    END LOOP;

    dbms_output.put_line('Commiting ' || driver_records.COUNT);
    -- commit the batch
    COMMIT;

  END LOOP;  

  CLOSE cur_get_driver_recs;

END;