Delete procedure

[michell rosvlet]

 
CREATE OR REPLACE PROCEDURE EMPLOYEE_DEL( 
P_EMPSAL EMPLOYEE.EMP_SAL%TYPE) AS
P_VALUE NUMBER(6,2);
BEGIN
P_VALUE := P_EMPSAL;
IF P_VALUE < 650 THEN
DELETE FROM EMPLOYEE WHERE EMP_SAL < 650;
ELSE
DBMS_OUTPUT.PUT_LINE('NOTTING DELETED');
END IF;
END  EMPLOYEE_DEL;

 

Can any one tell me where I am going wrong in this procedure.

[michell rosvlet]

GOT IT