使用Python cx_Oracle运行更新查询只会使系统挂起，并且不会生成异常

尝试运行更新查询，但它只是停滞不前，没有任何输出

有人可以查看我编写的以下代码，并检查错误之处。使用Oracle SQL Developer手动尝试时，相同的查询工作正常。

query = """update PRODUCTNAMES set SHORT_TEXT_VALUE = :1 where UID in 
        (select UID from PRODUCTUID where PID in
        ('ab12','ed90','bv78') AND LOCALIZED_ATTRIBUTE_KEY = :2)"""
con = cx_Oracle.connect(username, password,
                                    host/service)
cursor = con.cursor()                                   

cursor.execute(query,['CARRY,EASY','WearableSubtype'])
con.commit()
cursor.close()
con.close() \`  \`  \` 

问题来源：stackoverflow