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;