Connected to Oracle Database 11g Release 11.2.0.1.0 
Connected as supermag@//192.168.1.201/DBOFFICE

SQL> create table active(id number not null, name varchar2(100) not null, status number default 0 not null);

Table created


SQL> insert into active values (1, 'Утюг', 0);

1 row inserted


SQL> insert into active values (2, 'Телефон', 1);

1 row inserted



SQL> 
SQL> create trigger active_trg after insert or delete or update on active for each row
  2  
  3  begin
  4    if nvl(:new.status, :old.status) = 1 then
  5      raise_application_error(-20001, 'Нельзя менять строки со статусом 1.');
  6    end if;
  7  end;
  8  /

Trigger created



SQL> update active set name = 'Утюг старый' where id = 1;

1 row updated


SQL> update active set name = 'Телефон списанный' where id = 2;
update active set name = 'Телефон списанный' where id = 2

ORA-20001: Нельзя менять строки со статусом 1.
ORA-06512: at "SUPERMAG.ACTIVE_TRG", line 3
ORA-04088: error during execution of trigger 'SUPERMAG.ACTIVE_TRG'

SQL>