Tries to execute an Oracle query and writes out failing values. Note: you have to turn on dbms_output in SQL Developer first.

log_failing_oracle_rows.sql

declare
d date;
  begin
      for i in (select * from properties_csv) loop
          begin
              d:= to_date(i.sale_date, 'yyyymmdd');
          exception
              when others then
                  dbms_output.put_line('KO: "' || i.sale_date || '"');
          end;
      end loop;
  end;
/