title: PL/SQL PROCEDURE name is already used by an existing object
body: <p>so i wrote down a procedure which should take 2 parameters name and death age. After that it checks if the value of the age is null where name is ... . If it is null it should update the table if not give a following message. But after trying to execute the query i get an </p>
  
  <p>ORA-00955: name is already used by an existing object
  00955. 00000 -  "name is already used by an existing object"</p>
  
  <p>errors which i dont know how to solve.</p>
  
  <pre><code> SET SERVEROUTPUT ON
  
  CREATE PROCEDURE set_death_age(input_PRES_NAME IN PRESIDENT.PRE_NAME%TYPE , input_DEATH_AGE IN PRESIDENT.DEATH_AGE%TYPE) IS
  
  Dage PRESIDENT.DEATH_AGE%TYPE;
  
  BEGIN
  
  --Dage := &amp;Enter_death_age;
  
              SELECT DEATH_AGE  INTO Dage
              FROM PRESIDENT
              WHERE PRES_NAME = input_PRES_NAME;
  
  
              IF Dage is null
              THEN
  
              UPDATE PRESIDENT
              SET DEATH_AGE = input_DEATH_AGE
              WHERE PRES_NAME = input_PRES_NAME;  
              DBMS_OUTPUT.PUT_LINE('Updated');
                      ELSE 
                      DBMS_OUTPUT.PUT_LINE('President is dead');
              END IF;
  
              EXCEPTION 
              WHEN NO_DATA_FOUND THEN
              DBMS_OUTPUT.PUT_LINE('No such president found');
  
              WHEN OTHERS THEN
              DBMS_OUTPUT.PUT_LINE('Errorrrrrrr');
  
  END;
  </code></pre>