title: Got "ORA-01008: not all variables bound" from a sample query (Oracle APEX)
body: <p>I entered the following to the APEX</p>
  
  <pre><code>INSERT INTO hr.departments 
         (department_id, department_name, location_id)
  VALUES     (&amp;department_id, '&amp;department_name',&amp;location);
  </code></pre>
  
  <p>That's from the powerpoint. I got the following error:</p>
  
  <blockquote>
    <p>ORA-01008: not all variables bound</p>
  </blockquote>
  
  <p>Can someone please explain and why it got that error? Thank you so much for the help!</p>