title: Error on sql oracle PL/SQL: Statement ignored
body: <p>This SQL code is giving me the error "Error at line 2: PL/SQL: Statement ignored ", Im working on SQL oracle application express / APEX: I tried everything I can think of and it gives me different problems everytime.</p>
  
  <pre><code>CREATE or replace TRIGGER remove_artista 
     instead of delete on V_ARTISTA
  REFERENCING old AS orow
  FOR EACH ROW
  BEGIN
  if exists(select * from Utilizadores where pessoaID = orow.pessoaID) then
          delete from Pessoas where pessoaID = orow.pessoaID;
  ELSE
          delete from Artistas where pessoaID = orow.pessoaID;
          delete from Pessoas where pessoaID = orow.pessoaID;
  end if;
  END;
  </code></pre>
  
  <p>The view:</p>
  
  <pre><code>create or replace view v_artista as 
   select 
  pessoaID, nome_p, sexo, data_nasc, nome_art, biografica
  from Pessoas natural inner join Artistas;
  </code></pre>
  
  <p>EDIT: fixed a litle typo on the code.</p>