which seems to be more a feature of the ETL tool, than anything else. As soon as Oracle returns an 'Invalid Number' error, it just gives the indication that it has read in all the records it needs to, and continues with the rest of the program. Which is a bit scary.

The fun part has been altering a colleague's attitude from 'Your program is wrong!' to 'Oh, uh, you fixed my SQL? Umm, thanks...' :)