trigger가 포함된 테이블 내 merge into SQL 수행 시 TBR-10005: NOT NULL 발생

SQL> drop table t1; drop table t2; SQL> create table t1 (c1 number not null, c2 number not null, c3 number not null); SQL> create table t2 (c1 number not null, c2 number not null, c3 number not null); SQL> insert into t1 values (1, 2, 3); SQL> commit; SQL> create or replace trigger trg1 after update or delete or insert on t1 for each row declare begin insert into t2 (c1, c2, c3) values (:new.c1, :new.c2, :new.c3); end; / 패치 전 에러 발생 SQL> merge into t1 using (select 1 c1 from dual) A on (t1.c1 = A.c1) when matched then update set c3 = 10; TBR-20000: TBR-10005: NOT NULL constraint violation ('SCH'.'SLES126L'.'BEGIN_YY')..TBR-15163: Unhandled exception at SCH.TR_SLES126_AR11_1, line 161. 패치 후 정상 동작 결과값 SQL> merge into t1 using (select 1 c1 from dual) A on (t1.c1 = A.c1) when matched then update set c3 = 10; 1 row merged.