我正在读取一个包含5列的csv文件并推送到oracle表
我知道有很多资源。。但即使那样我也找不到解决问题的办法
将CSV读取到python的代码:import csv
reader = csv.reader(open("sample.csv","r"))
lines=[]
for line in reader:
lines.append(line)
print lines
输出:[['Firstname', 'LastName', 'email', 'Course_name', 'status'],
['Kristina', 'Bohn', 'abc@123.com', 'Guide to
Capnography in the Management of the Critically Ill Patient (CE)',
'Registered'], ['Peggy', 'Lutz', 'gef@123.com',
'Guide to Monitoring EtCO2 During Opioid Delivery (CE)', 'In
Progress']]
将列表推送到Oracle表的代码:import cx_Oracle
con = cx_Oracle.connect('username/password@tamans*****vd/Servicename')
ver=con.version.split(".")
print(ver)
cur=con.cursor()
cur.execute("INSERT INTO TEST_CSODUPLOAD ('FIRSTNAME','LASTNAME','EMAIL','COURSE_NAME','STATUS') VALUES(:1,:2,:3,:4,:5)",lines)
con.commit ()
cur.close()
我得到了错误:
数据库错误:ORA-01484:数组只能绑定到PL/SQL语句
请帮我解决这个问题谢谢