Oracle 数据库 函数不能读异常，各位谁知道什么原因呢，先谢过大家了

Question

INSERT INTO HR_ANNUAL_LEAVE_HISTORY_BAK
(LEAVE_HISTOY_ID,
ANNUAL_LEAVE)
SELECT GET_NEW_ID LEAVE_HISTOY_ID,

NVL(F_HR_GET_HOLIDAY_DAYS_T('78508490'), 0) ANNUAL_LEAVE
FROM DUAL

            上面的插入语句报错：
            ORA-04091: 表 YXT.HR_ANNUAL_LEAVE_HISTORY_BAK 发生了变化, 触发器/函数不能读它

ORA-06512: 在 "YXT.F_HR_GET_HOLIDAY_DAYS_T", line 65

堆栈信息中显示行数代码：
65行：SELECT COUNT(1)
INTO L_FLAG
FROM HR_ANNUAL_LEAVE_HISTORY_BAK H
WHERE H.USER_CODE =
(SELECT USER_CODE FROM HR_USERS U WHERE U.USER_ID = P_USER_ID)
AND H.LEAVE_YEAR = TO_CHAR(SYSDATE, 'YYYY');
IF (L_FLAG > 0) THEN
SELECT H.ANNUAL_LEAVE
INTO RESULT
FROM HR_ANNUAL_LEAVE_HISTORY_BAK H
WHERE H.USER_CODE =
(SELECT USER_CODE FROM HR_USERS U WHERE U.USER_ID = P_USER_ID)
AND H.LEAVE_YEAR = TO_CHAR(SYSDATE, 'YYYY');
END IF;

Answer 1

insert操作会影响函数中select的结果，所以结果将不可预知，从而oracle认定有错，从而不执行。你最好检查一下逻辑，确认是否真的要这样insert？然后再考虑如何解决