Feb 032014
 
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!

 Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>