Interesting question Dwalin. In my opinion, its knowing that you would die adhering to the oath and that you will be known as true Cosa Nostra. Ratting is Ratting no matter what, even in a revenge scenario.
Do you or anyone have any other examples besides Costello?