Exception Handling

Question 1

User defined exceptions

Answer 1

Apart from system exception we can define exceptions based on business rules

Question 2

Steps to follow to use user defined exceptions

Answer 2

Explicitly declared in declaration section

Explicitly raised in the execution section using Raise or DBMS_STANDARD.RAISE_APPLICATION ERROR (built in proc in oracle) displays error message and number

When using google this transactions not committed are rolled back within the block
Raises and exception but doesn’t handle it

Handled by referencing the user defined exception name in the Exception section