Python interface to Oracle Database
Project description
python-oracledb
python-oracledb is a Python programming language extension module allowing Python programs to connect to Oracle Database. It is the renamed, new major release of the popular cx_Oracle driver.
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.
Synchronous and concurrent coding styles are supported.
Installation
Run python -m pip install oracledb
See python-oracledb Installation.
Dependencies and Interoperability
-
Python versions 3.7 through 3.12.
Prebuilt packages are available for these Python versions on Windows, on macOS and on Linux.
Source code is also available.
-
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 11.2 through 21c.
-
Oracle Database
Thin mode: Oracle Database 12.1 (or later) is required.
Thick mode: Oracle Database 11.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 19c libraries, then it can connect to Oracle Database 11.2 or later.
Documentation
See the python-oracledb Documentation and Release Notes.
Samples
Examples can be found in the /samples directory and the Python and Oracle Database Tutorial.
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.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distributions
Hashes for oracledb-2.1.2-cp312-cp312-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8c1eaf8c74bb6de5772de768f2f3f5eb935ab935c633d3a012ddff7e691a2073 |
|
MD5 | ef6af28e5fd67600bea06b03995f4d0b |
|
BLAKE2b-256 | d90c10de170751fbe74233111dcfe5142f1cce7541673994b53892dbc210b7b6 |
Hashes for oracledb-2.1.2-cp312-cp312-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1e3ffdfe76c97d1ca13a3fecf239c96d3889015bb5b775dc22b947108044b01e |
|
MD5 | bc77a2c3248921d8aa234fadc75ca446 |
|
BLAKE2b-256 | 391c98cb195cf6d9ca3388be1eb95bce823fcee1631a03af11c908fce6f86d65 |
Hashes for oracledb-2.1.2-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1d590caf39b1901bcba394fcda9815438faff0afaf374025f89ef5d65993d0a4 |
|
MD5 | 30cf040047583a9ec5f17d5716b44e03 |
|
BLAKE2b-256 | 6b830c1749571905fd0f13f08a1c4823bba2f1ec40604bfc515c8a801891ce4a |
Hashes for oracledb-2.1.2-cp312-cp312-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | de5c932b04d3bcdd22c71c0e5c5e1d16b6a3a2fc68dc472ee3a12e677461354c |
|
MD5 | 1fa7ac515f26cabd4968968fc7a7de35 |
|
BLAKE2b-256 | a8ae8cc92b249695a5068c2ee922bb960af459495dc10d61be7f7e62eb1337aa |
Hashes for oracledb-2.1.2-cp312-cp312-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 08aa313b801dda950918168d3962ba59a617adce143e0c2bf1ee9b847695faaa |
|
MD5 | ea178e49c5c56bec5f97942c2a378152 |
|
BLAKE2b-256 | 61ff57dba00343c578fe7fab59982406ff00faf8f0ce29f969d135071e0c30a3 |
Hashes for oracledb-2.1.2-cp311-cp311-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9edce208c26ee018e43b75323888743031be3e9f0c0e4221abf037129c12d949 |
|
MD5 | 119bf86978bf6f9e7dba9ef10cbd1ad3 |
|
BLAKE2b-256 | 059ac9551c9f3ae2c367751086d2b0db106f5c7a6215dbe473443cc56c07d77a |
Hashes for oracledb-2.1.2-cp311-cp311-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a043b4df2919411b787bcd24ffa4286249a11d05d29bb20bb076d108c3c6f777 |
|
MD5 | 0518b614af406d32719b294cf2437e8c |
|
BLAKE2b-256 | be0e121b0c28d2823508a93d372e09d45d0677464d2ea5588b91d607aa6735e4 |
Hashes for oracledb-2.1.2-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 50225074841d5f9b281d620c012ced4b0946ff5a941c8b639be7babda5190709 |
|
MD5 | 8135b289ac1d085526c9d7ab189b8627 |
|
BLAKE2b-256 | a1a48a1dd860f2005ae5d2248263453d7ec92e06d0351059a868e4024fff361c |
Hashes for oracledb-2.1.2-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c53827344c6d001f492aee0a3acb6c1b6c0f3030c2f5dc8cb86dc4f0bb4dd1ab |
|
MD5 | 2a78240c08d466a9833f0eac2c7d0c51 |
|
BLAKE2b-256 | 26961d016d90fcee21dc62888deec4d42c52232e897ccb95ef55eaadf85e7f20 |
Hashes for oracledb-2.1.2-cp311-cp311-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b913a164e1830d0e955b88d97c5e4da4d2402f8a8b0d38febb6ad5a8ef9e4743 |
|
MD5 | 9459231d9e8749e7d7ca60c4472072e6 |
|
BLAKE2b-256 | 9170c3186c789bee67089edbde14892facafe8105351e6acdab93b6b8355ea54 |
Hashes for oracledb-2.1.2-cp310-cp310-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 92620efd5eb0d23b252d75f2f2ff1deadf25f44546903e3283760cb276d524ed |
|
MD5 | ffd0853d73cf3787dafa4c4365731a46 |
|
BLAKE2b-256 | 94c49ee8ee6deae715b072ae2779b91a7e40e919778c1eed0d42c611afec2836 |
Hashes for oracledb-2.1.2-cp310-cp310-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3b3798a1220fc8736a37b9280d0ae4cdf263bb203fc6e2b3a82c33f9a2010702 |
|
MD5 | c71db5f1088bd645d83d3762bd773012 |
|
BLAKE2b-256 | c20e4cb861aae1d370945cd2899c44e2ea2efa74b47aef9d32752ada930be958 |
Hashes for oracledb-2.1.2-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | bde2df672704fbe12ab0653f6e808b1ed62de28c6864b17fc3a1fcac9c1fd472 |
|
MD5 | ac28b4219c7fdeb7a9e2924ba560b7bf |
|
BLAKE2b-256 | b0c39af5a8cf0dcdea9262d8de23e8d554707374c15afacc9ea7d411b33e4099 |
Hashes for oracledb-2.1.2-cp310-cp310-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 71d98deb1e3a500920f5460d457925f0c8cef8d037881fdbd16df1c4734453dd |
|
MD5 | f91a73681310e2e23eae04b15aaf68c4 |
|
BLAKE2b-256 | 3012e5047cdb7197e86788c60e7ed448f52ed43dd835036dc1caaef35bc0ceb4 |
Hashes for oracledb-2.1.2-cp310-cp310-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4ffaba9504c638c29129b484cf547accf750bd0f86df1ca6194646a4d2540691 |
|
MD5 | c2d307d0c41cfcecf353597bc831019d |
|
BLAKE2b-256 | 606b7b534528578b5f90f7258bd97db946f358a42421c44b5fc9fbb42040767f |
Hashes for oracledb-2.1.2-cp39-cp39-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 69bde9770392c1c859b1e1d767dbb9ca4c57e3f2946ca90c779d9402a7e96111 |
|
MD5 | 703363e1150196ca444dd3e03becabca |
|
BLAKE2b-256 | 173f783f766d5610bab6f843247d1715df19d4b456a21bd3413e2caa3c31ebdd |
Hashes for oracledb-2.1.2-cp39-cp39-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5d4f6bd1036d7edbb96d8d31f0ca53696a013c00ac82fc19ac0ca374d2265b2c |
|
MD5 | 710aefc96ef9733753c6c1b6117d0a42 |
|
BLAKE2b-256 | cb673a67aed45a8cd75552e630d25604d87afc82e2a248d3529c3012b7c3120f |
Hashes for oracledb-2.1.2-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e5bc03520b8bd4dbf2ac4d937d298a85a7208ffbeec738eea92ad7bb00e7134a |
|
MD5 | 1d486542e26fac3eef78332ff9b7fa08 |
|
BLAKE2b-256 | e10a3e7726f546a8a9d6f4f22c9e74f61b66431f3966e4fd7e28bdbf83999e67 |
Hashes for oracledb-2.1.2-cp39-cp39-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0f22c31b894bb085a33d70e174c9bcd0abafc630c2c941ff0d630ee3852f1aa6 |
|
MD5 | 2fe5b8dd8c394c4628d1e924ef8dfa5b |
|
BLAKE2b-256 | 481cff66f9b9ed19670d85ec54c92daa2e779331d50e0a2a3f6f665bc771de86 |
Hashes for oracledb-2.1.2-cp39-cp39-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8eb688dd1f8ea2038d17bc84fb651aa1e994b155d3cb8b8387df70ab2a7b4c4c |
|
MD5 | 72ca7a5243419b1c609462c08ea38455 |
|
BLAKE2b-256 | 3b85fca13182193806f850ad5bb07a9cc0e9613792a586e601760ed97baa6a0e |
Hashes for oracledb-2.1.2-cp38-cp38-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d9a6447589f203ca846526c99a667537b099d54ddeff09d24f9da59bdcc8f98b |
|
MD5 | db7dd119b6a3b730f3d6606ae782b472 |
|
BLAKE2b-256 | fc05561ae67474d5b312eccd3ba625f54ce18e57609ed8629d58cbf4ac25b3c3 |
Hashes for oracledb-2.1.2-cp38-cp38-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9a9a6e0bf61952c2c82614b98fe896d2cda17d81ffca4527556e6607b10e3365 |
|
MD5 | 23925b836b18f3b2b89fb44f460c274d |
|
BLAKE2b-256 | 3ad04e3fc0639a51d1fc6e2dfcd1bb0f8c04cf35a14ce5992288833384316c67 |
Hashes for oracledb-2.1.2-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1a2d9891244b9b94465e30af8cc79380bbb41081c5dc0511cbc94cc250e9e26d |
|
MD5 | 9813e4b0f4d37c6427940d823d078943 |
|
BLAKE2b-256 | 64d082fc1dbf2cf1a563fcdae0e5dc96d6ef5d793ac54d753c96a2a86738e906 |
Hashes for oracledb-2.1.2-cp38-cp38-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 391034ee66717dba514e765263d08d18a2aa7badde373f82599b89e46fa3720a |
|
MD5 | 1f5d0cc723709a92cc8956bd5bf48e81 |
|
BLAKE2b-256 | eae7170144e4b6b4a4bf0ff1a6b6d25b05efab4841640d2094f58a4cb19d6387 |
Hashes for oracledb-2.1.2-cp38-cp38-macosx_11_0_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f94b22da87e051e3a8620d2b04d99e1cc9d9abb4da6736d6ae0ca436ba03fb86 |
|
MD5 | d8ad1a12bafb546c286fcb9851502280 |
|
BLAKE2b-256 | ecde58e03a32a532d2e84bf7c0aa3e41d7bda28f3b5431d6b0179f84f49e4a58 |
Hashes for oracledb-2.1.2-cp37-cp37m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0ea32b87b7202811d85082f10bf7789747ce45f195be4199c5611e7d76a79e78 |
|
MD5 | 20147db370bd3ac568c7d971e685034a |
|
BLAKE2b-256 | d577b75d61120adb6a0f717afa04e142ed4b556d7f3566062a45b62072e365f5 |
Hashes for oracledb-2.1.2-cp37-cp37m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b5d936763a9b26d32c4e460dbb346c2a962fcc98e6df33dd2d81fdc2eb26f1e4 |
|
MD5 | f917f9788d9336f5769c2b439e753725 |
|
BLAKE2b-256 | 3cd8f7f5782355ee68210966c1d070a0507f4e452275c1ad659f754ecc5be4ed |
Hashes for oracledb-2.1.2-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b337f7cf30753c3a32302fbc25ca80d7ff5049dd9333e681236a674a90c21caf |
|
MD5 | 56cd51715d3a89c360b944a6559d051a |
|
BLAKE2b-256 | 6e01e6709273230641e4a33fc23e7b0243ddb51b0478a5d80dd421d5d70b7ae2 |
Hashes for oracledb-2.1.2-cp37-cp37m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1a21d84aaf5dddab0cfa8ab7c23272c0295a5c796f212a4ce8a6b499643663dd |
|
MD5 | f99f4237f641c56afd2b18cc20a0f432 |
|
BLAKE2b-256 | e7d2ba7a0837cccfd2419cbd84ccc9cee2cd38c0d40de91d7abd781f196ce51b |
Hashes for oracledb-2.1.2-cp37-cp37m-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e2ee06e154e08cc5e4037855d74dc6e37dc054c91a7a1a372bb60d4442e2ed3d |
|
MD5 | 0d3a863e5a204ae5a681e30129caad8f |
|
BLAKE2b-256 | dc660e72bbd34d986a7fc18c1e194dbae78a45567b137150c1ee8aae5f855244 |