title: Value of a NEW variable on a trigger not changing, on plsql
body: <p>I'm loading data through Oracle Apex utilities using a datasheet.</p>
  
  <p>I want to make a trigger that checks for a value on the table from the data loaded, and then changes it depending on what it gets.</p>
  
  <p>The table has 4 columns: id,name,email,type</p>
  
  <p>The data to load is something like this: name,email,type</p>
  
  <p>Now my trigger:</p>
  
  <pre><code>create or replace TRIGGER  BI_USER
  before insert ON USER               
  for each row  
  
  declare
  begin   
    if :NEW.ID is null then
      select USERID_SEQ.nextval into :NEW.ID from dual;
    end if;
   :NEW.TYPE := 'something else';
  end; 
  </code></pre>
  
  <p>The ID works great, it takes a number from the sequence, but :new.type isn't working, it doesn't change.
  I also run the SQL insert separately and the same happens.</p>
  
  <p>EDIT:
  new.type type is char(1), I wrote it like this just for testing yet it doesn't change...
  aah I'm dissapoint of myself, it throws the error just after reading the data and never fires the trigger.</p>
  
  <p>What I was trying to do is that it will have the name of the TYPE column, and put the id from that table into the NEW.type</p>
  
  <p>Is there a way to change the NEW type?</p>