CREATE OR REPLACE PACKAGE state_pkg
AS
  v_rows_affected NUMBER;
END state_pkg;
/

CREATE OR REPLACE TRIGGER your_table_bud
  BEFORE UPDATE OR DELETE ON your_table
BEGIN
  state_pkg.v_rows_affected := 0;
END your_table_bud;
/

CREATE OR REPLACE TRIGGER your_table_audr
  AFTER UPDATE OR DELETE ON your_table
  FOR EACH ROW
BEGIN
  state_pkg.v_rows_affected := state_pkg.v_rows_affected + 1;
END your_table_audr;
/

CREATE OR REPLACE TRIGGER your_table_aud
  AFTER UPDATE OR DELETE ON your_table
BEGIN
  IF state_pkg.v_rows_affected > 100
  THEN
    RAISE_APPLICATION_ERROR 
      (-20001, 
       'You are not allowed to perform an update or delete on more than 100 rows.');
  END IF;
END your_table_aud;
/