I get a trigger mutation
create or replace trigger RF_TEST_SHIPTO
before delete on SHIPTO
for each row
if :old.STSTAT <>'P'
insert into TEST_SHIPTO select * from shipto;
Let me know
You can't insert a row in the DELET trigger. Better handle it in application. Or you need to create a view, and then insert it.
You can reference greate solution on the following website:
search by mutate table or so, there you go.
The best way to handle these situations is to create a package. Within the package, create a table of records and two triggers: a row trigger and an "after" statement trigger. Record the data being deleted into the table of records during the row trigger processing then manipulate the database as needed in the statement trigger using the table of records. Thus no table access occurs during mutation.
Click Here to Expand Forum to Full Width