The best example to follow would be Java implementation of try-catch-finally. However in PL/SQL it would get messy and the code would remind good ol' spaghetti western with epic theme - The Good, The ...