When Others Exception

[Glowworm27]

I was hoping someone could clarify something for me.

I was reading the Online Documentation about dealing with exceptions and I was wondering about the When Others Exception.

If I do not list any other type of exception in my Exception block, will the When Others Exception catch ALL errors?

EXCEPTION
		When Others Then
		err_msg := SUBSTR(SQLERRM, 1, 200);
		Insert Into Payroll_Exceptions
		Values(Payroll_Exception_ID_Seq.Nextval, systimestamp, 'spInsertLabor_Dist', err_msg , oCreateDate, Null, Null, Null);

or do I need at least one other type of exception preceding the When Others Statement?

Thanks in advance

George Oakes
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net

 

[sem]

It catches ALL not catched exceptions.

Regards, Dima

http://seminihin.narod.ru

 

[Glowworm27]

Thanks Dima!!
I was hoping that was the case.

George Oakes
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net

 

[amrita418]

One point to remember though:
When others traps all exceptions that are not yet handled so this should always be the last exception handler in the exception block.

Regards,
AA

 

[SantaMufasa]

Sem and Amrita are absolutely correct. I'll add just one clarification: "WHEN OTHERS..." must be the last exception handler in an exception section, otherwise, Oracle (PL/SQL) throws a interpret-time error.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.

 

[Glowworm27]

OK I knew it had to be the last handler in the exception block. My question was if it is the only handler in the exception block would it catch All exceptions?

And I think Sem has answered that for me. Thanks everyone for your guidance.


George Oakes
Check out this awsome .Net Resource!

http://www.learnvisualstudio.net