Hi Masters,
I have attended an interview last week. They asked questions on exceptions. I didn't gave proper answers because of little bit confuse. Ofcourse these are basic questions.
questions
1. I have pl/sql block with declare, begin, exception and end parts. If I give Raise keyword in begin / exception part what will happens?
2. In the begin section I have called user defined exception, then it will go and execute the statements in the exception part. again pointer will come back to main block(begin part) or not ? If I have some more dml statements are there in the main block those will execute or not?
3. Are there any rules to write exceptions in a proper order ?
4. If I give when others then exception in the first place what will happens? why we have to write when others then exception in the last place?
Please advise...!!
Regards
AR