Oracle exception block

In the exception part,what will happen if u don’t give (when others) where will it show error compile time or run time

Questions by nabiel_pathan

Showing Answers 1 - 3 of 3 Answers

Giriraj Gupta

  • Feb 26th, 2012
 

Run time

  Was this answer useful?  Yes

Mark Haynes

  • Feb 27th, 2012
 

Now, to clarify, I am taking the following statement; "in the exception part, what will happen if you don't give the (when others) statement" to mean an exception block with no other when statements as well, in that case, an error would show at compile time.

If there were other when statements in the exception the code would compile, if an exception occurred and the other could not handle the error, then the handling of the error would be be moved up the calling stack until it was either handled or the application terminated because of the un-handled run-time error.

  Was this answer useful?  Yes

NAND

  • Feb 27th, 2012
 

It will give the error at run time if it is not able to find the type of exception thrown in the current PL/SQL block or the outer block.
It will not throw the compile time error.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions