Contents
How to delete trigger and prevent deletion?
If an attempt to delete an entry from T1 is captured, create an entry in the EVENT_DETAILS and the record will not be deleted from T1. When rollback, EVENT_DETAILS row will not be rollback. I’ve tried in 3 ways. 1. Trigger code and Put Insert statement (COMMIT) in a procedure as pragma autonomous transaction.
How to create before delete trigger in SQL?
SQL> SQL> create table err ( d date, x int ); Table created. SQL> SQL> create or replace 2 trigger TRG 3 before delete on T 4 for each row 5 declare 6 pragma autonomous_transaction; 7 begin 8 insert into err values (sysdate,:old.x); 9 commit; 10 raise_application_error (-20000,’No you cannot delete’); 11 end; 12 / Trigger created.
When does rollback, event _ details row will not be rollback?
When rollback, EVENT_DETAILS row will not be rollback. I’ve tried in 3 ways. 1. Trigger code and Put Insert statement (COMMIT) in a procedure as pragma autonomous transaction.
Is there a trigger to prevent a record from being deleted?
Im trying to create an instead of trigger that fires when record is attempted to be deleted that key exist in a master table. ( I know the main way forr this to be done is a foreign key constraint, but that cannot be used because of business logic believe me i tried).
How to write trigger to prevent delete in Salesforce?
Can some one help me to write a trigger to prevent delete of all Account records and its supporting test class. Doesn’t matter who the user is (Sys Admin/Custom Profile/Read Only…etc), the user should not be able to delete the account record. There cannot be any exception.
How to prevent a delete from Stack Overflow?
Alternatively, you could use an instead of trigger to prevent the delete from taking place: You can make use of commit after your delete statement and rollback after that to reach to the previous stage using Pragma. Thanks for contributing an answer to Stack Overflow!