title: cx_Oracle.DatabaseError: ORA-01036: illegal variable name/number
body: <p>I am trying load a csv file into the oracle database and facing this error :</p>
  
  <blockquote>
    <p><strong><em>cx_Oracle.DatabaseError: ORA-01036: illegal variable name/number</em></strong></p>
  </blockquote>
  
  <p>Can you please help to understand the root cause and possible fix for this issue?</p>
  
  <pre><code>def main():
      ConStr = 'UserName/PWD@END_POINT'
      con = cx_Oracle.connect(ConStr)
      cur = con.cursor()
      with open('Persons.csv','r') as file:
                      read_csv = csv.reader(file,delimiter= '|')
                      sql = "insert into Persons (PERSONID,LASTNAME,FIRSTNAME,ADDRESS,CITY) values (:1,:2,:3,:4,:5)"
                      for lines in read_csv :
                              print(lines)
                              cur.executemany(sql,lines)
      cur.close()
      con.commit()
      con.close();
  </code></pre>
  
  <p>My csv file looks like below :</p>
  
  <pre><code>PERSONID|LASTNAME|FIRSTNAME|ADDRESS|CITY
  001|abc|def|ghi|jkl
  002|opq|rst|uvw|xyz
  </code></pre>