cx_Oracle.DatabaseError:ORA00911:无效字符

Question

以下是我的Python代码：

x,y,z= input("Enter a Three value: ").split() 
comp=input("Company's Name: ")

tkt = intkt

import cx_Oracle

connection = cx_Oracle.connect("PAY", "PAY", "192.200.168.15/XE")
cursor = connection.cursor()

query="select TICKETNO,PERIOD,PARAMETERVALUE from transaction where PARAMETERCODE = '01' and COMPANYCODE = :comp AND ticketno in {:x, :y, :z}"

cursor.execute( query, (comp,x,y,z))
 
for ticketno,period, PARAMETERVALUE in cursor:
  print(ticketno,period, PARAMETERVALUE)

以下是运行此文件时出现的错误：

Traceback (most recent call last):
  File "C:\python-programs\NoOfDaysquery1.py", line 29, in <module>
    cursor.execute( query, (comp,x,y,z))
cx_Oracle.DatabaseError: ORA-00911: invalid character 

我无法理解错误消息的含义以及如何解决它

Answer 1

尝试使用“（”而不是“{”：

query="select TICKETNO,PERIOD,PARAMETERVALUE from transaction where PARAMETERCODE = '01' and COMPANYCODE = :comp AND ticketno in (:x, :y, :z)"