title: declare variables in a pl/sql block
body: <p>I am trying to follow this <a href="http://infolab.stanford.edu/~ullman/fcdb/oracle/or-plsql.html" rel="nofollow">guide</a> for creating <code>pl/sql</code> blocks and I am getting an ORA-00922:missing or invalid option on the <code>SET orderNumberSEQ...</code>.  What am I doing wrong?</p>
  
  <pre><code>declare
  orderNumberSEQ number(5);
  userid varchar(20);
  
  begin
  insert into bs_orders (userid, ono, timepurchased)
  values('lilith', orderNum_seq.NEXTVAL,(SELECT current_timestamp FROM dual));
  
  SET orderNumberSEQ := orderNum_seq.CURRVAL;
  
  SELECT userid FROM bs_orders
  where ono = orderNumberSEQ;
  end;
  /
  </code></pre>