CREATE OR REPLACE TRIGGER TRG_MCOURSE_DML_DEL
    BEFORE 
    DELETE ON TBL_MSUB
    FOR EACH ROW
DECLARE
    V_MIN       NUMBER(10);
    V_MAX       NUMBER(10);
BEGIN    
    IF(DELETING)
       THEN   
              SELECT TO_NUMBER(SUBSTR(MIN(START_DATE),1,4)||SUBSTR(MIN(START_DATE),6,2)||SUBSTR(MIN(START_DATE),9,2))
                 , TO_NUMBER(SUBSTR(MAX(END_DATE),1,4)||SUBSTR(MAX(END_DATE),6,2)||SUBSTR(MAX(END_DATE),9,2)) INTO V_MIN, V_MAX
            FROM TBL_MSUB
            WHERE MCOURSE_CODE = (SELECT MCOURSE_CODE
                                 FROM  TBL_MCOURSE
                                 WHERE MCOURSE_CODE =:OLD.MCOURSE_CODE);
            
            UPDATE TBL_MCOURSE
            SET   MCSTART_DATE = TO_DATE(SUBSTR(TO_CHAR(V_MIN),1,4)||SUBSTR(TO_CHAR(V_MIN),5,2)||SUBSTR(TO_CHAR(V_MIN),7,2), 'YYYY-MM-DD')
            WHERE MCOURSE_CODE = (SELECT MCOURSE_CODE
                                 FROM TBL_MCOURSE
                                 WHERE MCOURSE_CODE = :OLD.MCOURSE_CODE) AND MCSTART_DATE > :OLD.START_DATE;
                                 
            UPDATE TBL_MCOURSE
            SET   MCEND_DATE = TO_DATE(SUBSTR(TO_CHAR(V_MAX),1,4)||SUBSTR(TO_CHAR(V_MAX),5,2)||SUBSTR(TO_CHAR(V_MAX),7,2), 'YYYY-MM-DD')
            WHERE MCOURSE_CODE = (SELECT MCOURSE_CODE
                                 FROM TBL_MCOURSE
                                 WHERE MCOURSE_CODE = :OLD.MCOURSE_CODE) AND MCEND_DATE<:OLD.END_DATE;
   
    END IF;
END;

참조하는 테이블을 검색해서 다른 테이블을 업데이트 하려고하는데 SELECT 로 참조자체를 못하는데 해결방법이있을까요 ㅠㅠㅠㅠ

ORA-04091: table TEAM4.TBL_MSUB is mutating, trigger/function may not see it