Need help with a PL/SQL exercise ? Exceptions.
705399Jun 5 2009 — edited Jun 7 2009hello !
Im very new on pl/sql. So i need the syntax, im use the HR-schema. So here is the exercise.
Create a package (EXC_PKG) which contains only one exception declaration type SALARY_TO_HIGH Exception.
Create another package (SETSAL_PKG) with a procedure (SET_NEW_SAL) that allows update of salary on the table Employee
at a designated employee.
The program will test that salary does not exceed 6000.
If the Salary is greater than 6000 then the application should use the exception in the package EXC_PKG
and display the message: Salary (<new Salary>) shall not be greater than 6000.
Thx for help!
Love from me