错误:ORA-00955:Oracle Function中的现有对象已使用该名称 [英] Error: ORA-00955: name is already used by an existing object in Oracle Function

问题描述

我有要尝试编译的功能，并得到错误，显示为Error: ORA-00955: name is already used by an existing object.我真的不知道此错误，并尝试搜索此问题，但未找到任何解决方案.我不知道这与任何授予特权有关，但我的架构表没有特权问题.

I have function which i am trying to compile and getting an error as Error: ORA-00955: name is already used by an existing object. 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.

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;

推荐答案

您可能还有另一个具有相同名称(PERFORM_CHECK)的对象.

You probably have another object with the same name (PERFORM_CHECK).

您可以通过查询user_objects来找到它:

You can find it by quering user_objects:

select *
from   user_objects
where  object_name = 'PERFORM_CHECK'

然后将其删除(用上面的查询中的对象类型替换TYPE_OF_OBJECT):

Then drop it (replace TYPE_OF_OBJECT by the type of the object from the above query):

 drop TYPE_OF_OBJECT perform_check

这篇关于错误:ORA-00955:Oracle Function中的现有对象已使用该名称的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！