title: Error: ORA-00955: name is already used by an existing object in Oracle Function
body: <p>I have function which i am trying to compile and getting an error as <code>Error: ORA-00955: name is already used by an existing object</code>. I am really not aware of this error and try to search for this issue but did not find any solution. I dont know is this related to any grant priviledges but i dont have priviledges issue to my schema tables.</p>
  
  <pre><code>create or replace FUNCTION "AK_CHECK" 
  -- PUBLIC
  (ID Number) RETURN Number
  IS
    TYPE_ID Number := 0;
    SUCCESS Number := 0;
    S Number := 0;
  BEGIN
    SELECT ACTIVE(ID) + MANUAL(ID) INTO S FROM DUAL;
    CASE S
    WHEN 2 THEN
     SELECT TYPE INTO TYPE_ID
     FROM SALE_SUPPLY KD
     WHERE KD.KPI_DEF_ID = ID;    
    END CASE;
  END AK_CHECK;
  </code></pre>