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