title: Set BindByName in PL/SQL
body: <p>I have problem with bind variables (to be specyfic with its default setting BindByPosition). For example, I have procedure such as:</p>
  
  <pre><code>DECLARE
      v_sql varchar2;
  BEGIN
      v_sql := 'select :1 as field1, :1 as field2 from dual';
      EXECUTE IMMEDIATE v_sql USING 'test', 'test';
  END;
  </code></pre>
  
  <p>Now I need to type 'test' twice. How can I change BindByName to true, to have procedure like this:</p>
  
  <pre><code>DECLARE
      v_sql varchar2;
  BEGIN
      v_sql := 'select :1 as field1, :1 as field2 from dual';
      EXECUTE IMMEDIATE v_sql USING 'test';
  END;
  </code></pre>