上次這個可以執行

import oracledb

A = oracledb.SessionPool(user="AP_SAMANTHA_TC_YU", password="XXX", host="172.17.241.246", port="5211", service_name="TSID")
conn = A.acquire()
cursor = conn.cursor()

sql = "SELECT ODS_SYSTEM.SF_ENCODE_WORD(:1) FROM dual"
with open('a.txt', 'r') as f:
    values = f.readlines()

newvalues = [num.strip() for num in values]

with open('b.txt', 'a') as f:
    for i in newvalues:
        cursor.execute(sql, (i,))
        result = cursor.fetchone()
        f.write(str(result[0]) + '\n')

為什麼今天這個報錯

import oracledb

A = oracledb.SessionPool(user="AP_SAMANTHA_TC_YU", password="XXX", host="172.17.241.246", port="5211", service_name="TSID")
conn = A.acquire()
cursor = conn.cursor()

sql = "select js_name from ODS_SYSTEM.RD_JOBINFO where jobname = '(:1)'"

with open('js.txt', 'r') as f:
    values = f.readlines()

newvalues = [num.strip() for num in values]

with open('b.txt', 'a') as f:
    for i in newvalues:
        cursor.execute(sql, (i,))
        result = cursor.fetchone()
        f.write(str(result[0]) + '\n')

報錯

oracledb.exceptions.DatabaseError: DPY-4009: 0 positional bind values are required but 1 were provided