title: Stuck on PL/SQL: ORA-00933: SQL command not properly ended
body: <p>I can't see my error.  I marked the places SQL Developer is citing errors.  Can you see where I am going wrong?  ZCTA5_2000 is a valid table with data.</p>
  
  <pre><code>CREATE OR REPLACE TRIGGER zip_trigger
    BEFORE INSERT ON ZCTA5_2000
    FOR EACH ROW
  DECLARE
    low_zip NUMBER(5);
    high_zip NUMBER(5);  &lt;---  Error PL/SQL: SQL Statement ignored  ******
  BEGIN  &lt;-----Error PL/SQL: ORA-00933: SQL command not properly ended ********
  
    SELECT LOW_ZIP, HIGH_ZIP FROM ZIPTABLE
    INTO low_zip, high_zip
    WHERE :NEW.STATE = STATE_CODE;  &lt;--- Error PLS-00103: Encountered the symbol "END"... 
      IF :NEW.ZIP &lt; LOW_ZIP OR :NEW.ZIP&gt;HIGH_ZIP
      END IF;
  END;
  </code></pre>