title: Oracle trigger probably issue with :new
body: <pre><code>create trigger Trigger_1
      Before INSERT
      on Adresse
      for each row
      declare
          pruefen int;
  begin
      select COUNT(*) 
      into pruefen 
      from CITY 
      where city.NAME = :new.stadt 
      and CITY.PROVINCE = :new.provinz;
      if(pruefen = 0) then
          RAISE_APPLICATION_ERROR(-20000, 'Fehler');
      end if;
  end;
  </code></pre>
  
  <p>Error:</p>
  
  <blockquote>
    <p>[2020-01-18 10:14:12] [72000][20000] ORA-20000: Fehler<br>
    [2020-01-18 10:14:12] ORA-06512: in "ZOGL1011.TRIGGER_1", Row 6<br>
    [2020-01-18 10:14:12] ORA-04088: error during execution of Trigger "ZOGL1011.TRIGGER_1"<br>
    [2020-01-18 10:14:12] Position: 12</p>
  </blockquote>
  
  <p>I don't get the problem.. <code>:new.stadt</code> and <code>:new.provinz</code> are in red, but I can create the trigger.</p>
  
  <p>Thank you for your help!</p>