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 [email protected]
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
-~----------~----~----~----~------~----~------~--~---
