Python SQL查询变量未调用值
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可用，但我遇到了此错误，但我是否以错误的格式调用变量！
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: missing or invalid session ID
Though serial/ session id is available yet i am getting this error, am i calling variables in wrong format!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
在Oracle中，双引号适用于标识符，而单语引号用于字符串文字；您想要一个字符串字面。
In Oracle, double quotes are for identifiers and single quotes are for string literals; you want a string literal.