title: Using PL/SQL variables in OCI results in "ORA-01008: not all variables bound" error
body: <p>The following (highly contrived and simplified) example runs fine in SQLDeveloper, but results in an ORA-01008 error when run through OCI.</p>
  
  <pre><code>declare
    CURRENT_LINE_ID NUMBER := 120;
    TARGETVAR NUMBER;
  begin
    SELECT 1 INTO TARGETVAR FROM DUAL WHERE 120 = :CURRENT_LINE_ID;
  end;
  </code></pre>
  
  <p>Is there any way to restructure this so that the bind variable is satisfied in OCI?</p>
  
  <p>I experimented with <a href="http://www.oracle.com/technetwork/testcontent/sub-var2-099853.html" rel="nofollow">substitution variables</a> a little (again works in SQL Developer), but DEFINE appear to be completely invalid in OCI.</p>
  
  <pre><code>DEFINE MYSUBST = 120;
  DECLARE
    TARGETVAR NUMBER;
  BEGIN
    SELECT 1 INTO TARGETVAR FROM DUAL WHERE 120 = &amp;MYSUBST;
  END;
  </code></pre>