you could use "return" but that would be considered very poor coding practice. begin begin if 1 / 0 = 1 then null; end if; exception when others then DBMS_OUTPUT.put_line ('error'); return; end; exception when others then DBMS_OUTPUT.put_line ('here'); end;
On Thu, Sep 18, 2008 at 8:43 AM, oldyork90 <[EMAIL PROTECTED]> wrote: > > Is there a way to raise nothing, just to get out of a program from a > nested block? if #1 stuff dies, > I don't want #2 stuff to run. > > block > > block > do somthing #1 > exception > when something_1_bad_1 > then > process bad 1 > raise -- just to get out; > end; > > do more stuff #2 > > exception -- outer block > when others > then > process errors > end; > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---