PLSQL_7_3_Practice.docx - 1 www.oracle.com/academy Database...

1
Database Programming with PL/SQL
7-3:
Trapping User-Defined Exceptions
Practice Activities
Vocabulary
Identify the vocabulary word for each definition below:
RAISE_APPLICATION_E
Use this statement to raise a named exception.
Try It / Solve It
All the questions in this exercise use a copy of the employees table. Create this copy by running the
following SQL statement:
1. Create a PL/SQL block that updates the salary of every employee to a new value of 10000 in a
chosen department. Include a user-defined exception handler that handles the condition where no
rows are updated and displays a custom message. Also include an exception handler that will trap
any other possible error condition and display the corresponding SQLCODE and SQLERRM. Test
your code three times, using department_ids 20, 30, and 40.

2