Modify the function to handle error

Question

How must you modify the function to handle error?

Answer 1

Modify the function to handle error:

1. An user defined exception should be declared and related with the error code and handled within the EXCEPTION section.

2. Handle the error within EXCEPTION section through referencing the error code directly.

3. Handle the error within the EXCEPTION section through referencing the UNIQUE_ERROR as predefined exception.

4. Check for success through checking the value of SQL%FOUND instantly after the UPDATE statement.