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.
