SQL & PL/SQL

I'm updating a date field with dates constructed from day, month and year fields. The incoming data has many instances of day and month that are not valid dates, ex 11 31 2007. There is no 31st day in November.

I would like to write a pl/sql script to scan the table containing these values and log the rows that produce conversion errors.

I thought I could do this with exceptions but there are no exceptions that correspond to the ORA-01847 error for mismatched day and month.

Here is what I tried (the print procedure is a local wrapper for DBMS_OUTPUT.put_line):

PROCEDURE date_check IS
start1 DATE ;

BEGIN
select to_date(nvl(yearcollected,'9999') ||'/'|| nvl(monthcollected,'01') ||'/'|| nvl(daycollected,'01'),'YYYY/MM/DD'))) into start1 from incoming_data where id=1 ;

BEGIN
update temp_test set test_date = start1 where id=1 ;

EXCEPTION
WHEN OTHERS THEN
print('Date error message from exception block');
END;
print('Processing continues after handling date exception') ;
END date_check ;

Is there a way to catch this kind of error and continue processing after logging a message?

-=beeky