在Python cx_oracle中添加请求超时

import cx_Oracle
import signal

def handle_timeout(signum, frame):
    raise TimeoutError("Oracle query timed out")

timeout = 10  # 设置超时时间为10秒
signal.signal(signal.SIGALRM, handle_timeout)  # 设置信号处理函数
signal.alarm(timeout)  # 设置信号闹钟，在timeout秒后发送SIGALRM信号

dsn = cx_Oracle.makedsn(host='hostname', port='port', sid='sid')
connection = cx_Oracle.connect(user='username', password='password', dsn=dsn)

cursor = connection.cursor()
try:
    cursor.execute("SELECT * FROM table_name")
    result = cursor.fetchall()
    for row in result:
        print(row)
except cx_Oracle.DatabaseError as e:
    print("Oracle query error:", e)
finally:
    cursor.close()
    connection.close()