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 #173 (comment)

[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