title: Why am I encountering the symbol end of file in Oracle?
body: <p>I'm trying to create a trigger for auto incrementing id value in Oracle. Here is the code that I've tried to use</p>
  
  <pre><code>create or replace 
  trigger themes_on_insert
  before insert on THEME
  for each row
  begin
  select themes_sequence.nextval
  into :new.ID
  from dummy
  end;
  </code></pre>
  
  <blockquote>
    <p>Error(5,4): PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:     ( begin case declare end exception exit for goto if loop mod    null pragma raise return select update while with          &lt;&lt; continue close current delete fetch lock    insert open rollback savepoint set sql execute commit forall    merge pipe purge </p>
  </blockquote>