Python Cx_oracle need to skip long running queries and move on to execute next query

[vbvasu]

Hi, Im trying to execute like 15-20 queries using cx_oracle python Some of the queries may run long sometimes i am searching for a way to stop the query if its still running for more than 30 min i would like to skip this and cancel the execution and gopn executing other queries. Is there anyway to track the time and cancel the query execution and skip this

_Originally posted by @vbvasu in https://github.com/oracle/python-cx_Oracle/issues/173#issuecomment-1933427823_

[anthony-tuininga]

You have a couple of options that immediately come to mind:

• use the call_timeout attribute on connections to force a break after the timeout expires (results in an exception)

• use a Python timer thread and then initiate a call to cancel the statement yourself (also results in an exception)

[cjbj]

@vbvasu A side comment: don't forget to schedule your upgrade to the latest version of cx_Oracle, which was released under the new name python-oracledb a couple of years ago, see the release announcement