This preview shows page 1. Sign up to view the full content.
Unformatted text preview: /* PROGRAM WITHOUT RAISE APPLICATION ERROR*/ CREATE OR REPLACE PROCEDURE raise_salary (emp_id NUMBER, amount NUMBER) AS curr_sal NUMBER BEGIN SELECT sal INTO curr_sal FROM emp WHERE empno = emp_id IF curr_sal IS NULL THEN raise NO_DATA_FOUND ELSE UPDATE emp SET sal = curr_sal + amount WHERE empno = emp_id END IF EXCEPTION when NO_DATA_FOUND then DBMS_OUTPUT.PUT_LINE('error') END raise_salary...
View Full Document
This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.
- Summer '10