python-oracledb

The python-oracledb driver is the widely used, open-source Python extension module allowing Python programs to connect directly to Oracle Database with no extra libraries needed. The module is built with Cython for safety and speed. It is lightweight and high-performance. It is stable, well tested, and has comprehensive documentation. The module is maintained by Oracle.

The module conforms to the Python Database API 2.0 specification with a considerable number of additions and a couple of minor exclusions, see the feature list. It is used by many Python frameworks, SQL generators, ORMs, and libraries.

Python-oracledb has a rich feature set which is easy to use. It gives you control over SQL and PL/SQL statement execution; for working with data frames; for fast data ingestion; for calling NoSQL-style document APIs; for message queueing; for receiving database notifications; and for starting and stopping the database. It also has high availability and security features. Synchronous and concurrent coding styles are supported. Database operations can optionally be pipelined.

Python-oracledb is the successor to the now obsolete cx_Oracle driver.

Python-oracledb Installation

Run:

python -m pip install oracledb --upgrade

See python-oracledb Installation for details.

Samples

Examples can be found in the /samples directory and the Python and Oracle Database Tutorial.

A basic example:

import oracledb
import getpass

un = "scott"                  # Sample database username
cs = "localhost/orclpdb"      # Sample database connection string
# cs = "localhost/freepdb1"   # For Oracle Database Free users
# cs = "localhost/orclpdb1"   # Some databases may have this service
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 sysdate from dual"
        for r in cursor.execute(sql):
            print(r)

Dependencies and Interoperability

Python versions 3.9 through 3.14.

Pre-built packages are available on PyPI and other repositories.

Source code is also available.

Previous versions of python-oracledb supported older Python versions.
Oracle Client libraries are optional.

Thin mode: By default python-oracledb runs in a 'Thin' mode which connects directly to Oracle Database.

Thick mode: Some advanced Oracle Database functionality is currently only available when optional Oracle Client libraries are loaded by python-oracledb. Libraries are available in the free Oracle Instant Client packages. Python-oracledb can use Oracle Client libraries versions 11.2 through 23, inclusive.
Oracle Database

Thin mode: Oracle Database 12.1 (or later) is required.

Thick mode: Oracle Database 9.2 (or later) is required, depending on the Oracle Client library version. Oracle Database's standard client-server version interoperability allows connection to both older and newer databases. For example when python-oracledb uses Oracle Client 19 libraries, then it can connect to Oracle Database 11.2 or later.

Documentation

See the python-oracledb Documentation and Release Notes.

Help

Questions can be asked in GitHub Discussions.

Problem reports can be raised in GitHub Issues.

Tests

See /tests

Contributing

This project welcomes contributions from the community. Before submitting a pull request, please review our contribution guide.

Security

Please consult the security guide for our responsible security vulnerability disclosure process.

License

See LICENSE, THIRD_PARTY_LICENSES, and NOTICE.

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

oracledb-3.4.0.tar.gz (851.2 kB view details)

Uploaded Oct 7, 2025 Source

Built Distributions

If you're not sure about the file name format, learn more about wheel file names.

The dropdown lists show the available interpreters, ABIs, and platforms. Enable javascript to be able to filter the list of wheel files.

oracledb-3.4.0-cp314-cp314-win_amd64.whl (1.9 MB view details)

Uploaded Oct 7, 2025 CPython 3.14Windows x86-64

oracledb-3.4.0-cp314-cp314-win32.whl (1.5 MB view details)

Uploaded Oct 7, 2025 CPython 3.14Windows x86

oracledb-3.4.0-cp314-cp314-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl (2.6 MB view details)

Uploaded Oct 7, 2025 CPython 3.14manylinux: glibc 2.17+ x86-64manylinux: glibc 2.28+ x86-64

oracledb-3.4.0-cp314-cp314-manylinux2014_aarch64.manylinux_2_17_aarch64.manylinux_2_28_aarch64.whl (2.4 MB view details)

Uploaded Oct 7, 2025 CPython 3.14manylinux: glibc 2.17+ ARM64manylinux: glibc 2.28+ ARM64

oracledb-3.4.0-cp314-cp314-macosx_10_15_universal2.whl (4.5 MB view details)

Uploaded Oct 7, 2025 CPython 3.14macOS 10.15+ universal2 (ARM64, x86-64)

oracledb-3.4.0-cp313-cp313-win_amd64.whl (1.9 MB view details)

Uploaded Oct 7, 2025 CPython 3.13Windows x86-64

oracledb-3.4.0-cp313-cp313-win32.whl (1.5 MB view details)

Uploaded Oct 7, 2025 CPython 3.13Windows x86

oracledb-3.4.0-cp313-cp313-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl (2.6 MB view details)

Uploaded Oct 7, 2025 CPython 3.13manylinux: glibc 2.17+ x86-64manylinux: glibc 2.28+ x86-64

oracledb-3.4.0-cp313-cp313-manylinux2014_aarch64.manylinux_2_17_aarch64.manylinux_2_28_aarch64.whl (2.4 MB view details)

Uploaded Oct 7, 2025 CPython 3.13manylinux: glibc 2.17+ ARM64manylinux: glibc 2.28+ ARM64

oracledb-3.4.0-cp313-cp313-macosx_10_13_universal2.whl (4.5 MB view details)

Uploaded Oct 7, 2025 CPython 3.13macOS 10.13+ universal2 (ARM64, x86-64)

oracledb-3.4.0-cp312-cp312-win_amd64.whl (1.9 MB view details)

Uploaded Oct 7, 2025 CPython 3.12Windows x86-64

oracledb-3.4.0-cp312-cp312-win32.whl (1.5 MB view details)

Uploaded Oct 7, 2025 CPython 3.12Windows x86

oracledb-3.4.0-cp312-cp312-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl (2.6 MB view details)

Uploaded Oct 7, 2025 CPython 3.12manylinux: glibc 2.17+ x86-64manylinux: glibc 2.28+ x86-64

oracledb-3.4.0-cp312-cp312-manylinux2014_aarch64.manylinux_2_17_aarch64.manylinux_2_28_aarch64.whl (2.4 MB view details)

Uploaded Oct 7, 2025 CPython 3.12manylinux: glibc 2.17+ ARM64manylinux: glibc 2.28+ ARM64

oracledb-3.4.0-cp312-cp312-macosx_10_13_universal2.whl (4.5 MB view details)

Uploaded Oct 7, 2025 CPython 3.12macOS 10.13+ universal2 (ARM64, x86-64)

oracledb-3.4.0-cp311-cp311-win_amd64.whl (1.9 MB view details)

Uploaded Oct 7, 2025 CPython 3.11Windows x86-64

oracledb-3.4.0-cp311-cp311-win32.whl (1.6 MB view details)

Uploaded Oct 7, 2025 CPython 3.11Windows x86

oracledb-3.4.0-cp311-cp311-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl (2.7 MB view details)

Uploaded Oct 7, 2025 CPython 3.11manylinux: glibc 2.17+ x86-64manylinux: glibc 2.28+ x86-64

oracledb-3.4.0-cp311-cp311-manylinux2014_aarch64.manylinux_2_17_aarch64.manylinux_2_28_aarch64.whl (2.6 MB view details)

Uploaded Oct 7, 2025 CPython 3.11manylinux: glibc 2.17+ ARM64manylinux: glibc 2.28+ ARM64

oracledb-3.4.0-cp311-cp311-macosx_10_9_universal2.whl (4.5 MB view details)

Uploaded Oct 7, 2025 CPython 3.11macOS 10.9+ universal2 (ARM64, x86-64)

oracledb-3.4.0-cp310-cp310-win_amd64.whl (1.9 MB view details)

Uploaded Oct 7, 2025 CPython 3.10Windows x86-64

oracledb-3.4.0-cp310-cp310-win32.whl (1.6 MB view details)

Uploaded Oct 7, 2025 CPython 3.10Windows x86

oracledb-3.4.0-cp310-cp310-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl (2.7 MB view details)

Uploaded Oct 7, 2025 CPython 3.10manylinux: glibc 2.17+ x86-64manylinux: glibc 2.28+ x86-64

oracledb-3.4.0-cp310-cp310-manylinux2014_aarch64.manylinux_2_17_aarch64.manylinux_2_28_aarch64.whl (2.5 MB view details)

Uploaded Oct 7, 2025 CPython 3.10manylinux: glibc 2.17+ ARM64manylinux: glibc 2.28+ ARM64

oracledb-3.4.0-cp310-cp310-macosx_10_9_universal2.whl (4.4 MB view details)

Uploaded Oct 7, 2025 CPython 3.10macOS 10.9+ universal2 (ARM64, x86-64)

oracledb-3.4.0-cp39-cp39-win_amd64.whl (1.9 MB view details)

Uploaded Oct 7, 2025 CPython 3.9Windows x86-64

oracledb-3.4.0-cp39-cp39-win32.whl (1.6 MB view details)

Uploaded Oct 7, 2025 CPython 3.9Windows x86

oracledb-3.4.0-cp39-cp39-manylinux2014_x86_64.manylinux_2_17_x86_64.manylinux_2_28_x86_64.whl (2.7 MB view details)

Uploaded Oct 7, 2025 CPython 3.9manylinux: glibc 2.17+ x86-64manylinux: glibc 2.28+ x86-64

oracledb-3.4.0-cp39-cp39-manylinux2014_aarch64.manylinux_2_17_aarch64.manylinux_2_28_aarch64.whl (2.5 MB view details)

Uploaded Oct 7, 2025 CPython 3.9manylinux: glibc 2.17+ ARM64manylinux: glibc 2.28+ ARM64

oracledb-3.4.0-cp39-cp39-macosx_10_9_universal2.whl (4.4 MB view details)

Uploaded Oct 7, 2025 CPython 3.9macOS 10.9+ universal2 (ARM64, x86-64)

File details

Details for the file oracledb-3.4.0.tar.gz.

File metadata

Download URL: oracledb-3.4.0.tar.gz
Upload date: Oct 7, 2025
Size: 851.2 kB
Tags: Source
Uploaded using Trusted Publishing? No
Uploaded via: twine/6.1.0 CPython/3.13.7

File hashes

Hashes for oracledb-3.4.0.tar.gz
Algorithm	Hash digest
SHA256	`3196f0b9d3475313e832d4fd944ab21f7ebdf596d9abd7efd2b2f7e208538150`
MD5	`c4b4c19e44190df8f3b2fb77b8081342`
BLAKE2b-256	`8d2447601e8c2c80b577ad62a05b1e904670116845b5e013591aca05ad973309`

Algorithm	Hash digest
SHA256	`e89031578e08051ce2aa05f7590ca9d3368b0609dba614949fa85cf726482f5d`
MD5	`0a8c592034e199c3406a59b565af21d8`
BLAKE2b-256	`5694679eabc8629caa5b4caa033871b294b9eef8b986d466be2f499c4cdc4bdd`

Algorithm	Hash digest
SHA256	`98689c068900c6b276182c2f6181a2a42c905a0b4d7dc42bed05b80d515bf609`
MD5	`d1393c5c6b5966f7f68e143d2f9a70b0`
BLAKE2b-256	`6c028d110e380cb7656ae5e6b91976595f2a174e3a858b6c7dfed0d795dc68ed`

Algorithm	Hash digest
SHA256	`b7b312896bafb7f6e0e724b4fc2c28c4df6338302ac0906da05a07db5666e578`
MD5	`8969517fd228035e6b410cd051974497`
BLAKE2b-256	`0308057341d84adbe4a8e73b875a9e732a0356fe9602f6dc6923edcc3e3aa509`

Algorithm	Hash digest
SHA256	`746154270932699235229c776ced35e7759d80cf95cba1b326744bebc7ae7f77`
MD5	`9f9f7248f7723991850323c1a1a93978`
BLAKE2b-256	`50e09b5e359ed800c632cbcf6517f8e345a712e1357bfe67e6d9f864d72bf6ae`

Algorithm	Hash digest
SHA256	`9d842a1c1f8462ca9b5228f79f93cfa7b7f33d202ab642509e7071134e8e12d2`
MD5	`1e97a0cc036a09b957d7c45c22154b9c`
BLAKE2b-256	`f0b4b6ad31422d01018121eeac961f8af8eb8cf39b7f3c00c3295ffc2c8b8936`

Algorithm	Hash digest
SHA256	`f752823649cc1d27e90a439b823d94b9a5839189597b932b5ffbeeb607177a27`
MD5	`7577254f4aad6766e1641c0013dac9f1`
BLAKE2b-256	`7573b102f11ca161963c29a1783a4589cac1b9490c9233327b590a6be1e52a61`

Algorithm	Hash digest
SHA256	`2038870b19902fd1bf2735905d521bbd3e389298c47c39873d94b410ea61ae51`
MD5	`a98b2b51dc7866114a7c146d37e99e6e`
BLAKE2b-256	`0505a4c6881b1d09893e04a12eaff01094aabdf9b0fb6b1cb5fab5aeb1a0f6c5`

Algorithm	Hash digest
SHA256	`0b1da9bbd4411bd53ddcfb5ce9a69d791f42f6a6c8cd6665cfc20d1d88497cc7`
MD5	`fa2544904105a2f651d146b430415acf`
BLAKE2b-256	`2530d426824d6f4cbb3609975c8c1beb6c394a47f9e0274306a1a49595599294`

Algorithm	Hash digest
SHA256	`3c32e7742cba933ca3271762d9565a0b2fdb8d3b7f03d105401834c7ea25831e`
MD5	`1a3695b1f8b9e268f3e40aa574b5fb8c`
BLAKE2b-256	`269c18e48120965870d1b395e50a50872748b5a369f924b10997ea64f069cc58`

Algorithm	Hash digest
SHA256	`70b5c732832297c2e1b5ea067c79a253edf3c70a0dedd2f8f269231fd0c649a3`
MD5	`663c95556df6a03efa679a3adcd17260`
BLAKE2b-256	`220ba154fb2d73130afffa617f4bdcd2debf6f2160f529f8573f833ce041e477`

Algorithm	Hash digest
SHA256	`ce9380e757f29d79df6d1c8b4e14d68507d4b1b720c9fd8a9549a0605364a770`
MD5	`432fce5fe6099a77fc44a157f5fe3191`
BLAKE2b-256	`7f74489d1758a7b13da1049a8c3cd98945ead0a798b66aefb544ec14a9e206ec`

Algorithm	Hash digest
SHA256	`f0f59f15c4dc2a41ae66398c0c6416f053efb1be04309e0534acc9c39c2bbbae`
MD5	`7c3fe5a68b57f444013057fc913d51eb`
BLAKE2b-256	`4661f2fb338e523fb00e091722954994289565674435bf0b0438671e1e941723`

Algorithm	Hash digest
SHA256	`7e59627831df8910a48a1650ef48c3e57a91399c97f13029c632d2ae311b49b3`
MD5	`b36f2014804daecc0ce5125800345efe`
BLAKE2b-256	`db9e10e4f13081e51e7a55b9ddd2e84657ff45576f1062b953125499a11b547e`

Algorithm	Hash digest
SHA256	`796cfb1ce492523379836bc4880b9665993e5cf5044a0fb55b40ab3f617be983`
MD5	`a49112cdfbcdab3cd13c89cd4abc071c`
BLAKE2b-256	`6635e16a31e5f0430c806aac564ebc13ccdae1bfe371b90c877255d0aff21e76`

Algorithm	Hash digest
SHA256	`4613fef1a0ede3c3af8398f5b693e7914e725d1c0fa7ccf03742192d1e496758`
MD5	`18204555704548fc7a103060883ca50f`
BLAKE2b-256	`dd9c7c7c9be57867842b166935ecf354b290d3b4cd7e6c070f68db3f71d5e0d4`

Algorithm	Hash digest
SHA256	`f400d30e1afc45bc54bde6fde58c5c6dddf9bc65c73e261f2c8a44b36131e627`
MD5	`b09806c7556aa7d5b01fef1d5925b3f5`
BLAKE2b-256	`eb3848a7dc4d8992bd3436d0a95bf85afafd5afd87c2f60a5493fb61f9525d7e`

Algorithm	Hash digest
SHA256	`90b0605b8096cfed23006a1825e6c84164f6ebb57d0661ca83ad530a9fca09d1`
MD5	`9473bd75873224b4d9245a6e110d62d3`
BLAKE2b-256	`33d01fcc2f312c8cb5ea130f8915b9782db1b5d2287a624dd8f777c81238a03e`

Algorithm	Hash digest
SHA256	`06384289b4c3bb1f6af9c0911e4551fab90d4e8de8d9e8c889b95d9dc90e8db8`
MD5	`d6f18b8f2fbd1803831fad160338a89e`
BLAKE2b-256	`1289d4f1f925bcf6151f8035e86604df9bd6472fe6a4470064d243d4c6cdf8df`

Algorithm	Hash digest
SHA256	`a8b260a495472212025409788b4f470d15590b0912e2912e2c6019fbda92aea9`
MD5	`307ce5d3c28cc268c0a04831cc92b65f`
BLAKE2b-256	`d6c95ff47cef222260eb07f9d24fdf617fd9031eb12178fe7494d48528e28784`

Algorithm	Hash digest
SHA256	`ea8d5b548657cf89fb3b9a071a87726a755d5546eb452365d31d3cdb6814d56b`
MD5	`ccada55628247e3964cefd9ca3d7c35d`
BLAKE2b-256	`b5f745b7be483b100d1d3b0f8620a1073b098b1d5eb00b38dd4526516b8e537d`

oracledb 3.4.0

python-oracledb

Python-oracledb Installation

Samples

Dependencies and Interoperability

Documentation

Help

Tests

Contributing

Security

License

Project links

Key dates

2 maintainers

Credits

License expression

Requires

Provides Extra

Tags

Classifiers

Download files

Source Distribution

Built Distributions

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

File details

File metadata

File hashes

Algorithm	Hash digest
SHA256	`d8687750374a947c12b05ffa2e7788fe93bb8cbf16cb1f231578381f47b976aa`
MD5	`0708fe7e00920e54ebe5ca11c54fb90d`
BLAKE2b-256	`e2da247fea207225e6b1fca6e74577b6748c944bb69b88884af44bf6b743f8d8`

Algorithm	Hash digest
SHA256	`2d43234f26a5928390cd9c83923054cf442875bd34f2b9b9b2432427de15a037`
MD5	`d8ffafaa242c5554e550bed85299f30a`
BLAKE2b-256	`00cdd5e6f2d24c78ce0fe0927c185334def7030ead903b314be8155cb910cafb`

Algorithm	Hash digest
SHA256	`10c3778c7994809fbb05d27b36f5579d7837a1961cc034cedb6c4808222c4435`
MD5	`d5cdca38f0917ca71becef02f101fcb7`
BLAKE2b-256	`6e2f3d1e8363032fcf4d0364b2523ea0477d902c583fe8cda716cb109908be9f`

Algorithm	Hash digest
SHA256	`e9517bc386edf91f311023f72ac02a55a69e2c55218f020d6359c3b95d5bf7db`
MD5	`eb014673f913449894648fc005311317`
BLAKE2b-256	`bd5e7a7abac9b3fe1cea84ed13df8e0558a6285de7aa9295b6fda1ab338f7cb2`

Algorithm	Hash digest
SHA256	`90e5036599264837b9738202e50b4d6e0a16512fbdd0a8d7bdd18f44c4ab9e4a`
MD5	`a6c56974edc5de0335260e63c9229c0a`
BLAKE2b-256	`eaac1315ecabc52ef5c08860e8f7eebd0496748a7ad490f34476e9a6eaa9277b`

Algorithm	Hash digest
SHA256	`10cd40e00a1ff411a8a6a077d076442a248dd2ec083688ac2001f9ab124efc54`
MD5	`d7207787e53d3bb60e0cb54ffd9d42d7`
BLAKE2b-256	`4657a466492132573138ebcb75d8ba263810e16f23c7d812eafe9e3562044bb8`

Algorithm	Hash digest
SHA256	`99b6bf68e3ee1227584b2b0a0cb18410c177e4fe7d04a16c23938011571bba3a`
MD5	`433df705857f932c822d24505c04d98b`
BLAKE2b-256	`90a0474d74b188065676f2400a4f41d02534fa47d1f66554c47534d450f02ca3`

Algorithm	Hash digest
SHA256	`5cc94c5b25c160a14909119e4ac6222464da9cb398dbdb2fa4b551b7628fe056`
MD5	`86abae5245bba413a0123991b84b7522`
BLAKE2b-256	`3a1eab648276086dbff0f86a7ce93f88e5f02ede289e29c8d0a7223db78a0f3e`

Algorithm	Hash digest
SHA256	`d183373a574612db274782ab4fc549b1951d611ca68d34f98d53a9ed8ed210aa`
MD5	`196942be30ad12aaf0c42e9a327e9d52`
BLAKE2b-256	`c02f56cb00f126a8329729ed253709f1ddcd23883f8339010d4d114995a9b181`

Algorithm	Hash digest
SHA256	`2f9b815ae60eaccc73abece18683d6984f7fc793eca9a451578ad3cbf22c8ae9`
MD5	`a9706d571b37e4ae99de1bc9ba2fa230`
BLAKE2b-256	`878deade29811654cf895055378868c262fdf1d6dafae28eabee87a6e71eb28c`