title: Python - cx_oracle Update throws ORA-01036
body: <p>our UPDATE statement looks like this:</p>
  <pre><code>upd = &quot;&quot;&quot;UPDATE prices \
           SET pre_after_price = :1, \
               volume = :2, \
               pre_after_updated = SYSDATE + INTERVAL '1' HOUR \
           WHERE ticker = :3&quot;&quot;&quot;
  </code></pre>
  <p>Then, the actual code is this:</p>
  <pre><code>cursor.execute(upd,([pre_after_price, volume, ticker]))
  </code></pre>
  <p>But rather, we get this error:</p>
  <pre><code>ORA-01036: illegal variable name/number
  dpiStmt_bindByPos: bind by position
  </code></pre>
  <p>Is there something we are doing wrong?</p>