In the database, after adding a new record, it is necessary to replace the value in the column with 0. He gave birth to the following trigger using Google:

create or replace trigger AutoDisabled after insert on SCHEMA."Reason" for each row begin :new. "AutoEnabled" := 0; end;

When executing the trigger tightly hung Toad. What have I done wrong?

  • one
    I don’t know about toad, but the field can only be modified before trigger, not after . Although it shouldn't lead to any kind of hangings, it’s just an error - Mike

0