如何将python列表插入到特定的Oracle数据库列中?

conn = cx_Oracle.connect(conn_str)
c = conn.cursor()
c.execute(u'select NO,ITEM,STATUS,STATUS1 from MSDS_VII')
a=[]
b=[]
e=[]
f=[]
for row in c:
    e.append(row[0])
    f.append(row[1])
    a.append(row[2])
    b.append(row[3])
d=[[k,l,i,j] for k,l,i,j in zip(e,f,a,b)]
print(d)
print("\n")
for i in d:
    if(i[2]==1):
        i[3]="ON"
    elif(i[2]==0):
        i[3]="OFF"
    else:
        i[3]="NULL"
print(d)
for i in d:
    c.execute( 'insert into MSDS_VII(STATUS1 ) values (%s)',i[3])
conn.close()

Output:

[[1, 'item1', 1, None], [2, 'item2', 0, None], [3, 'item3', 1, None], [4, 'item4', 1, None], [5, 
'item5', 0, None]]


[[1, 'item1', 1, 'ON'], [2, 'item2', 0, 'OFF'], [3, 'item3', 1, 'ON'], [4, 'item4', 1, 'ON'], [5, 
'item5', 0, 'OFF']]


Traceback (most recent call last):
File "C:/Users/Admin/Desktop/status.py", line 28, in <module>
c.execute( 'insert into MSDS_VII(STATUS1 ) values (%s)',i[3])
cx_Oracle.DatabaseError: ORA-01036: illegal variable name/number

Database description