java.sql.SQLException ORA-06575 程序包或函数 ISHOLIDAY 处于无效状态

IT__LS

已于 2024-02-21 20:51:24 修改

阅读量1k

点赞数 8

CC 4.0 BY-SA版权

分类专栏：面试 Mysql 文章标签：数据库 sql oracle

于 2024-02-21 20:25:20 首次发布

本文链接：https://blog.youkuaiyun.com/IT__LS/article/details/136219860

create OR REPLACE FUNCTION isHoliday(MKT_Code   varchar2, D_Stand_Date date) return NUMBER as
  temp int;
begin
  select count(1)
    into temp
    from vb_holiday a
   where a.D_DATE = D_Stand_Date
     and a.C_HDay_Code in
         (select C_HDay_Code
            from T_TABLE_MKT b
           where b.C_MKT_Code = MKT_Code);
  if temp > 0 then
    return 1;
  else
    return 0;
  end if;
end;
/

-- 删除对应的函数
DROP FUNCTION ISHOLIDAY
-- 查询函数是否有效  详细信息
select * from user_objects t where t.OBJECT_NAME = 'ISHOLIDAY'

SELECT * FROM USER_OBJECTS WHERE OBJECT_TYPE = 'FUNCTION' and OBJECT_NAME = 'ISHOLIDAY'; 


--可从USER_SOURCE表中查看自定义函数的SQL脚本
SELECT * FROM USER_SOURCE WHERE NAME = 'ISHOLIDAY';

在PL/SQL中右键EDIT函数,发现编译报错缺少视图vb_holiday

创建视图后删除函数重新创建,查看user_objects 变为有效