title: SQL Trigger Statement ignored
body: <p>It should ensure that you can set only predefined values else it shows error. I get error</p>
  
  <blockquote>
    <p>Error at line 6: PL/SQL: Statement ignored<br>
    4. FOR EACH ROW<br>
    5. DECLARE<br>
    6. v_stru VARCHAR2(50);</p>
  </blockquote>
  
  <pre><code>CREATE OR REPLACE TRIGGER radnici_strucna_sprema
   BEFORE INSERT OR UPDATE OF STRUCNA_SPREMA ON radnici
  FOR EACH ROW
  DECLARE
    v_stru VARCHAR2(50);
  BEGIN
    v_stru := :NEW.strucna_sprema;
    IF v_ss = 'osnovno' THEN
      :NEW.strucna_sprema := v_stru;
    ELSIF v_ss = 'srednje' THEN
      :NEW.strucna_sprema := v_stru;
    ELSIF v_ss = 'vise' THEN
      :NEW.strucna_sprema := v_stru;
    ELSIF grade = 'visoko' THEN
      :NEW.strucna_sprema := v_stru;
    ELSE
      RAISE_APPLICATION_ERROR(NUM =&gt; -20002, 
              MSG =&gt; 'Forma strucne spreme nije odgovarajuca!');
    END IF;
  END;
  </code></pre>