title: Error on Trigger SQL Oracle
body: <p>Hi I'm having a problem while I'm creating a trigger on SQL Oracle.</p>
  
  <p>My trigger is:</p>
  
  <pre><code>    create or replace trigger generatePassword
  before insert on people
  for each row
  begin
      insert into people(nif,naame,date_birth,sex,adress,email,iban,password)
      values (:NEW.nif,:NEW.naame,:NEW.date_birth,:NEW.sex,:NEW.adress,:NEW.email,:NEW.iban,(select round(dbms_random.value(0000,9999)) from dual));
  end;
  /
  </code></pre>
  
  <p>The trigger was created successfully. Then, when I try to run the command:</p>
  
  <pre><code>insert into people (naame, date_birth, sex, adress, email, iban, nif, id) values ('Albert', '01-12-87', 'M', 'NY', 'albert@gmail.com', '000032134537512343231', '523456189', '70');
  </code></pre>
  
  <p>I get this error: </p>
  
  <blockquote>
    <p>ORA-00036: maximum number of recursive SQL levels (50) exceeded
    ORA-06512: at "UTF8.GENERATEPASSWORD", line 2 ORA-04088: error during
    execution of trigger 'UTF8.GENERATEPASSWORD' ORA-06512: at
    "UTF8.GENERATEPASSWORD", line 2 ORA-04088: error during execution of
    trigger 'UTF8.GENERATEPASSWORD' ORA-06512: at "UTF8.GENERATEPASSWORD",
    line 2 ORA-04088: error during execution of trigger
    'UTF8.GENERATEPASSWORD' ORA-06512: at "UTF8.GENERATEPASSWORD", line 2
    ORA-04088: error during execution of trigger '</p>
  </blockquote>
  
  <p>What is the problem here?</p>