title: Oracle "ORA-01008" Error. Variable Not Bound
body: <p>I have just started with <code>PL/SQL</code> and writing a simple fundamental code. I am not getting, what is wrong with the code.</p>
  
  <pre><code>DECLARE
  role_test varchar(40) := 'Programmer';
  BEGIN
  update veer_test set project_id=1008420 where role=:role_test;
  END;
  </code></pre>
  
  <p>I am getting <code>ORA-01008: not all variables bound</code>.</p>
  
  <p>Earlier I tried:</p>
  
  <pre><code>DECLARE
  role varchar(40) := 'Programmer';
  BEGIN
  update veer_test set project_id=1008420 where role=role;
  END;
  </code></pre>
  
  <p>This updated all the rows of the table. Well this was justifiable. But what if I want to use the same variable name as in the table. I also tried:</p>
  
  <pre><code>role=:role;
  </code></pre>
  
  <p>But same error <code>ORA-01008</code></p>