34 lines
750 B
Markdown
34 lines
750 B
Markdown
# Python cx_Oracle
|
|
|
|
**cx_Oracle was obsoleted by
|
|
[python-oracledb](https://oracle.github.io/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](https://github.com/oracle/python-oracledb).
|