Loading csv to orace using python

pyspark

#1

while loading a csv file into oracle getting below error, any idea ?

reader = csv.reader(open(“C:\inputs\sample_well3.csv”, “r”))
lines = []
for line in reader:
lines.append(line)
print("lines --> ",lines)

curs=conn.cursor()
curs.execute(“INSERT INTO DNS_TEMP_WELLS VALUES (:1, :2, :3, :4, :5, :6)”, lines)

ERROR :
File “C:/Users//PycharmProjects/Demo/temp_table_con.py”, line 21, in
curs.execute(“INSERT INTO TEMP VALUES (:1, :2, :3, :4, :5, :6)”, lines)
cx_Oracle.DatabaseError: ORA-01484: arrays can only be bound to PL/SQL statements


#2

What’s the cx_oracle version u r using?
Binding SQL types such as the one which u created is not supported in version prior to 5.3.


#3

cx version is 6.2

Thanks