title: TRIGGER AUTO_NUM_GEN compiled Warning: execution completed with warning
body: <p>I run the following statements in oracle sql developer using oracle 11g express as my database. I only run into problems when i try to create the trigger. I get the message - </p>
  
  <pre><code>TRIGGER AUTO_NUM_GEN compiled
  Warning: execution completed with warning 
  </code></pre>
  
  <p>The SQL- </p>
  
  <pre><code>CREATE TABLE myschema.mytable (mynums NUMBER PRIMARY KEY);
  CREATE SEQUENCE myschema.seq_of_nums MINVALUE 1 
  START WITH 1 INCREMENT BY 1 CACHE 10; 
  CREATE OR REPLACE TRIGGER myschema.auto_num_gen 
  BEFORE INSERT ON myschema.mytable FOR EACH ROW 
  BEGIN SELECT seq_of_nums.nextval INTO :new.mynums FROM DUAL; end; /
  </code></pre>
  
  <p>What is my mistake and why won't it work ?</p>
  
  <p>I ran the diagnostic query -</p>
  
  <pre><code>show errors trigger myschema.auto_num_gen;
  </code></pre>
  
  <p>And saw - </p>
  
  <pre><code>PLS-00103: Encountered the symbol "/" The symbol "/" was ignored
  </code></pre>
  
  <p>On the side,
  When the same code is run through java i also get the error -</p>
  
  <pre><code>java.sql.SQLSyntaxErrorException: ORA-04098: trigger 
  'MYTABLE.MYSCHEMA.AUTO_NUM_GEN ' is invalid and failed re-validation
  </code></pre>