begin raise my_database_is_on_fire; exception when others then dbms_output.put('Just ignore it...'); dbms_output.put('...it'll go out soon!'); end; /
This is a re-hash of my very first post. I wouldn’t normally repeat myself, but I’ve just been horribly burned by some code with “when others then null” blocks. This suppressed tablespace full errors, leading to data corruption and hasty data fixes.
If you must have “when others” exception blocks, please ensure you re-raise the error so it can be spotted and dealt with!