OraFAQ Forum: SQL & PL/SQL » How to pass the error ?

Home » SQL & PL/SQL » SQL & PL/SQL » How to pass the error ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to pass the error ? [message #193788]

Tue, 19 September 2006 07:22

jai_162
Messages: 21
Registered: July 2006

Junior Member

Hi ,

How to pass the error from inner Exception block to outer Exception block?

Eg:
begin
For Loop
Inner Exception
End Loop;
Outer Exception
end;

Report message to a moderator

Re: How to pass the error ? [message #193790 is a reply to message #193788]

Tue, 19 September 2006 07:31

Liza79
Messages: 74
Registered: September 2006

Member

just don't handle it in the inner exception part. It will automatically be raised to the outer one.

Report message to a moderator

Re: How to pass the error ? [message #193791 is a reply to message #193788]

Tue, 19 September 2006 07:32

aorehek
Messages: 52
Registered: August 2006

Member

BEGIN
  FOR i IN 1.. 10 LOOP
    BEGIN
       code
    EXCEPTION
      WHEN OTHERS THEN
         -- put som code in here 
         RAISE;
    END;   
  END LOOP;
EXCEPTION
  WHEN NO_DATA_FOUND THEN ....
  WHEN TOO_MANY_ROWS THEN ....
  WHEN OTHERS  THEN ...
    RAISE; -- go to next error_handler...
END;

Report message to a moderator

Previous Topic:	select distinct top 5 sal
Next Topic:	Distinct within a procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 12 17:54:42 CST 2025