Connection Timeout Parameter For Oracle Db From Python

I am using the below simple code to connect to Oracle database to execute a stored procedure. But am not seeing any timeout parameter anywhere while connecting to DB or executing t

Solution 1:

In general there are two ways to stop DB execution after a period of time.

• The Database has a resource manager than can be used to limit DB resources and return an error if they are exceeded.

• you can configure the Oracle Net layer used by cx_Oracle by creating a sqlnet.ora configuration file with various timeout parameters such as SQLNET.INBOUND_CONNECT_TIMEOUT, SQLNET.RECV_TIMEOUT and SQLNET.SEND_TIMEOUT etc. Check the Oracle Net Services documention.

For connections, use the latter