cx_Oracle was obsoleted by python-oracledb in 2022.
Python-oracledb uses the same Python DB API as cx_Oracle, and has many new features.
Install with:
python -m pip install oracledb
Usage is like:
import getpass
import oracledb
un = 'scott'
cs = 'localhost/orclpdb1'
pw = getpass.getpass(f'Enter password for {un}@{cs}: ')
with oracledb.connect(user=un, password=pw, dsn=cs) as connection:
with connection.cursor() as cursor:
sql = 'select systimestamp from dual'
for r in cursor.execute(sql):
print(r)
The source code for python-oracledb is at github.com/oracle/python-oracledb.