الكود 

create or replace PROCEDURE RAISE_SALARY
(ID IN EMPLOYEES.EMPLOYEE_ID, PERCENT IN NUMBER)IS
BEGIN
UPDATE EMPLOYEES
SET SALARY = SALARY*(1 + PERCENT /100);
WHERE EMPLOYEE_ID=ID;
END RAISE_SAL;

 

 

مرفق صوره

ID EMPLOYEES.EMPLOYEE_ID%TYPE

 

ابقى بص ع الايرورز

ID EMPLOYEES.EMPLOYEE_ID%TYPE

 

ابقى بص ع الايرورز

 

مشكور اخى الكريم

 

CREATE OR REPLACE PROCEDURE RAISE_SALARY (ID        IN EMPLOYEES.EMPLOYEE_ID%TYPE,

                                          PERCENT   IN NUMBER)

IS

Employee_Not_Found  EXCEPTION;

BEGIN

   UPDATE EMPLOYEES

      SET SALARY = SALARY * (1 + PERCENT / 100)

   WHERE EMPLOYEE_ID = ID;

   IF sql%rowcount = 0 THEN 

   RAISE Employee_Not_Found;

   END IF;

   COMMIT;   

   EXCEPTION 

   WHEN Employee_Not_Found THEN

   dbms_output.put_line('There is no such Employee Number'); 

 END RAISE_SALARY;

 

تم تعديل 19 أغسطس 201510 سنة بواسطة theunique

 

create or replace PROCEDURE RAISE_SALARY

(ID IN EMPLOYEES.EMPLOYEE_ID %type,PERCENT IN NUMBER)IS

BEGIN

UPDATE EMPLOYEES

SET SALARY=SALARY*(1 + PERCENT /100)

WHERE  EMP_number=ID;

END RAISE_SALARY;