title: UPDATE array execute many on python
body: <p>I have this python code :</p>
  
  <pre><code>valuesupdatehdr=[(0, '2019-05-03 22:18:22', 'vq-01'), (0, '2019-05-03 22:18:24', 've-01'), (0, '2019-05-03 22:18:24', 'vb-01'), (0, '2019-05-03 22:18:25', 'bv-01'), (0, '2019-05-03 22:18:26', 'bb-01'), (0, '2019-05-03 22:18:27', 'nnn-01'), (0, '2019-05-03 22:18:27', 'mmm-01'), (0, '2019-05-03 22:18:28', 'jj-01'), (0, '2019-05-03 22:18:29', 'kk-01'), (0, '2019-05-03 22:18:30', '66-01'), (0, '2019-05-03 22:18:31', '99-01'), (0, '2019-05-03 22:18:31', '11-01')]
  update_HDR="""UPDATE HHR_PENPA SET ACTIVE = TO_NUMBER(:ACTIVO) , INACTIVE_DATE = TO_DATE(:FECHA, 'YYYY-MM-DD HH24:MI:SS')  WHERE ORDERID =TO_CHAR(:ORDERID)""" 
          try:
              print("UPDATE en  HHR_PENPA")
              cursor.executemany(update_HDR, valuesupdatehdr)
              miConexion.commit()
          except Exception as e:
              print(str(e) + " ERROR  HHR_PENPA " + update_HDR + " " + str(valuesupdatehdr))
              miConexion.rollback()
              miConexion.commit()
  </code></pre>
  
  <p>When i run get me this problem.</p>
  
  <pre><code>ORA-00911: invalid character 
  
  </code></pre>
  
  <p>By other hand if run this :</p>
  
  <pre><code>UPDATE HHR_PENPA SET ACTIVE = TO_NUMBER(0) , INACTIVE_DATE = TO_DATE('2019-05-03 22:18:22', 'YYYY-MM-DD HH24:MI:SS')  WHERE ORDERID =TO_CHAR('vq-01')
  </code></pre>
  
  <p>Update correctly.</p>