title: Warning: Trigger created with compilation errors?
body: <p>I am trying to implement Trigger that raises an User Defined Error Message and does not allow  the update and Insert operation in the database.I am new to pl/sql i refereed some code from the internet and try to implement.My code is running is fine as i can not update/insert into database but still i am unable to get my user defined message and also i am getting this warning.</p>
  
  <pre><code>Warning: Trigger created with compilation errors ?
  </code></pre>
  
  <p>This is the table :</p>
  
  <pre><code> Name                                      Null?    Type
   ----------------------------------------- -------- ----------------------------
  
   ID                                                 NUMBER(5)
   NAME                                               VARCHAR2(20)
   SALARY                                             NUMBER(10)
   DEPOT_ADDRESS                                      VARCHAR2(15)
  </code></pre>
  
  <p>here is my code :</p>
  
  <pre><code>create or replace trigger cleaner_before_update_insert
  for update or insert on cleaner
  compound trigger
  count binary_integer;
  
  before statement is 
  begin
      count:=0;
  end before statement;
  
  after each row is 
  begin 
  count :=count +1;
  end after each row;
  
  after statement is 
  begin
      if count &gt; 0 then
          raise_application_error( -20001,'Update/insert operation can not be completed ');  
      end if;   
   end after statement;  
  
   end cleaner_before_update;
   /
  </code></pre>
  
  <p>can anyone help me figure out what is the problem here and way to fix it.
  thanks in advance.</p>
  
  <p>Even after compilation of the code it is giving me this error.</p>
  
  <pre><code>ORA-06512: at "SYSTEM.CLEANER_BEFORE_UPDATE_INSERT", line 18 
  ORA-04088: error during execution of trigger                                         
  'SYSTEM.CLEANER_BEFORE_UPDATE_INSERT' 
  </code></pre>