with open (r'D:\hang_sessions.csv') as csv_file:
csv_reader=csv.DictReader(csv_file,delimiter=',')
line_count=0
for row in csv_reader:
sid = row['SID']
serial = row['Serial']
inst = row['Inst_ID']
#User = row['User_Name']
#print(sid, serial, inst, User)
print(sid, serial, inst)
c.execute('alter system kill session ":sid, :serial,@:inst" immediate ')
cx_Oracle.DatabaseError: ORA-00026: 缺少或無效的會話 ID 雖然串行/會話 ID 可用但我收到此錯誤，我是否以錯誤的格式呼叫變數！
uj5u.com熱心網友回復：
在 Oracle 中，雙引號用于識別符號，單引號用于字串文字；你想要一個字串文字。
c.execute(f"alter system kill session '{sid},{serial},@{inst}' immediate")
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/488374.html
標籤：python-3.x 甲骨文 CX-甲骨文