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.1-cp312-cp312-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 29b000e4892f6c4eac6abe099bc43df9ccd586d9a02fa6391e0bd8e4eb88df37 |
|
MD5 | 25f7f0e15241687f62f0759703eca5c6 |
|
BLAKE2b-256 | 5102b85f85110d58458753869e9efe49f20f9a208b08a1c9fce56010eb00ebf2 |
Hashes for oracledb-2.1.1-cp312-cp312-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 50791fadf26e97a8cedcc1bf16ed5c5f0f2f1a0254e3725889e52eba1adc8f22 |
|
MD5 | 3b624dbe8ccee517e15ef8addec90814 |
|
BLAKE2b-256 | 1f74d82fe507a751f3419afa63a1ed84e2ee9d735b07052e51d7493b93c81f92 |
Hashes for oracledb-2.1.1-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7c16782bc37087947052f3d398be6e7d4bb3143a6863a5a1517f63c92c1b2b99 |
|
MD5 | 20e8442775089fceeed98061c434a1d3 |
|
BLAKE2b-256 | 06a663e1cb92206db3217d3d3c1ef5dff99fc8dcd0858ebdb09329e2afa42c78 |
Hashes for oracledb-2.1.1-cp312-cp312-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | eeb64b15c75b4d62fa060516d6bbd9f8f42272d677a48f6293597945836e9f0d |
|
MD5 | faa83ac897ea931baadc47d153306180 |
|
BLAKE2b-256 | 59610d649407fd2242c868bba991df69e1604f3c9ed03ef73860f6a773639250 |
Hashes for oracledb-2.1.1-cp312-cp312-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 166216272dcaaa2647fde3b7e13f9d3ffe0f05dc70791aacf7ba5e2c65c96aca |
|
MD5 | 3a0eccb3e8fba8983b35f12f15bb5759 |
|
BLAKE2b-256 | 9fe43ac322ee657c2e2ccb62c17c8cd3fffff61da46bb6a7b1e32f4abb1c548b |
Hashes for oracledb-2.1.1-cp311-cp311-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d539300667bf7af839baddb42896175c14d872cc0d903dace7850e91d90387f1 |
|
MD5 | 11a88ec67f5512839220bd25f89563f3 |
|
BLAKE2b-256 | 73ba84fd592bcedf70562eba5148efb7f7c5c8f523efeaa37efbf30b8e4bf907 |
Hashes for oracledb-2.1.1-cp311-cp311-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c0c29bdafe78d412bec20d91791dc91fc7feb9b63a39138a3ebd5835abf3639d |
|
MD5 | 0a7788b6c93ed9693ef588e3dcaa12f2 |
|
BLAKE2b-256 | 558c6d31bed83a748298fc8696d150404830cd530908d9e9be79ab0e243d9876 |
Hashes for oracledb-2.1.1-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d29cb729cd94e7afbfbef8f0d272bd8e20b16be77ae747686b677e9e9df0ad3f |
|
MD5 | b8c829ae59f4e235ed9c1233b9c930e3 |
|
BLAKE2b-256 | 460d344431f5c424864447aebfaa41436bd00d5b06fd4a9a4006078add5d701e |
Hashes for oracledb-2.1.1-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7cc8e853d33333c5e3cd4c2db0591c374c5fe06ebd713748b65c59be5b252054 |
|
MD5 | 066142f58fbb86c115bfb85705f3f15d |
|
BLAKE2b-256 | bfe797728b1a1c484661e2ee2500eda843fb4f1882f033d6334d6a0e798e6b66 |
Hashes for oracledb-2.1.1-cp311-cp311-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a94793243936117b4a8ea4a17672aa77f71c9063a176f0330ea733a48679d82c |
|
MD5 | 469383e00dda0e41c1a140628b7540a9 |
|
BLAKE2b-256 | bb7766ed1fcce7b7149f417155e4a1b1dcd99565187a66f048440f89a945431e |
Hashes for oracledb-2.1.1-cp310-cp310-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ec1012362c6ba5a465d87730c14bbbc3bac3a0799cd4371c6514364f2121dd42 |
|
MD5 | 688a7bd4081df1824b547692e9ba1b0b |
|
BLAKE2b-256 | 29d62fe434752659cd8e05d0d7cb1d4015e9752571f7880b7785cbb31d5d2ff7 |
Hashes for oracledb-2.1.1-cp310-cp310-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 962e0fce942eefafe8c52481c1979dd53c6929d479544499d2e32a1eb4111837 |
|
MD5 | 3cd7f80de180ab1b912646e1f3228a21 |
|
BLAKE2b-256 | 09ca3046ff0fad44dd290babe37a3c1982a773d261f3936a7e3ffdc2c6934ed9 |
Hashes for oracledb-2.1.1-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 06ede73b90c24387b47094aadae477a60e9c076d04275a7a5ae9deef0991e3a2 |
|
MD5 | 53d1b4230f2bc987b596a5e7d0c8a643 |
|
BLAKE2b-256 | ea59cee82762f3464a8277c6b7479caf29097135ff484af0e9a2e68ce792342f |
Hashes for oracledb-2.1.1-cp310-cp310-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8651ea5b9ef35493aa1bb80786458a26df3d728eb3e55b6bb9ddf2aa83f45be8 |
|
MD5 | d40f85b643e4d5d43cf9b17e2112c8d7 |
|
BLAKE2b-256 | fc44ac3985e31aca828cad05276d7c2c22ae921fc19395e1520d9fe9f0df4182 |
Hashes for oracledb-2.1.1-cp310-cp310-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0666088fcca29cfe8a8428888426655d2f7417adfb854ad0af79c40f1bae59aa |
|
MD5 | df52934954a1ea58f6f42f01b3eaf885 |
|
BLAKE2b-256 | 2e6017a44e607ad10897ac1c94e6af8d294fbf59c6dbbdb9f9e630942c4c5335 |
Hashes for oracledb-2.1.1-cp39-cp39-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1bf3ba201f21e8183a33b32ec1224b5d65b98ac0b1bf843b98b0b65ef34c1b26 |
|
MD5 | eb8be7dc2640224940eead8ecee92316 |
|
BLAKE2b-256 | 6204a60de6f8b32f7e0c1f1addc43f46b584c788e0cd668961b132e9b6bf2bd4 |
Hashes for oracledb-2.1.1-cp39-cp39-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 95c581d4df786d3aa6e2e47c8519b9036b28c1ea1416cf843b9572ba611a54d6 |
|
MD5 | 0516d65437385d4da8b19744ca2fbdd5 |
|
BLAKE2b-256 | 2c6a671fd80d24d935c5586d7eadfc4a16580a2daa5962fe2543b2c7490ad43c |
Hashes for oracledb-2.1.1-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | dce1f93bea32abd2d3dcfc17ed0546a20d36bc7a92b36ced58b525165fd63c8a |
|
MD5 | eecd77edca832003baa737f119ddd0ab |
|
BLAKE2b-256 | 1fa2721fa35ec5f280019bb4ed19903a5b1ebb7799ee04c3a3449066a95bd1c5 |
Hashes for oracledb-2.1.1-cp39-cp39-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b6c7b0aa7038d7444ea133a2439dc9b645fb5c81832dd24818c181494423f752 |
|
MD5 | 643f2db3e9d6dc85085cb6353869a2c1 |
|
BLAKE2b-256 | 12c3a387ddf20bdb3b6865bcf43fa2d7be1d11c79259b449c5b4208889d28841 |
Hashes for oracledb-2.1.1-cp39-cp39-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 479bcec29826ca2a49d1b113ca343ad31db8b94063d50223ab8d32c069faf4b3 |
|
MD5 | a4d8e2735a70014aa9e96d18558bd3e3 |
|
BLAKE2b-256 | 41d064045c8020afa01887d15a2074f93ea9b06e50fed407dc56df55c666934e |
Hashes for oracledb-2.1.1-cp38-cp38-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | bc013fac5009e6ebc65be58e7d3645aadd04ef8627553cdfe6e66a157963087a |
|
MD5 | 39f8a5551f08269ab81584ba4ce0b26f |
|
BLAKE2b-256 | 2ccde4f6f0d19955cbf1e23e57602b0eb09695cad3a3089cc1f9d1f930ca390e |
Hashes for oracledb-2.1.1-cp38-cp38-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1658760585f8c41e6530e25332ccdde3ca0b95b4e7c2a9a69719da0420da7fe6 |
|
MD5 | 55accc13a78d9d907b6bc659b03d4599 |
|
BLAKE2b-256 | 2bca7d84d629a60deffa0dbd0a61e8a61fa7edb554b21644d639a8372cf6b99f |
Hashes for oracledb-2.1.1-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9e7f9cb56e2d79a11f4b5a9233067b9eb327a30e6e8dad8349b02eca64482ab5 |
|
MD5 | df9b827a1b489b21e62f5deee346b763 |
|
BLAKE2b-256 | 9d4152d76e2f3181116f7836326b5d46c93934b5855483a30120e4de638855cb |
Hashes for oracledb-2.1.1-cp38-cp38-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8bba26b23d3e2905eb4c7627a9a1c31ad72c64442e184173c48f19bde2a92184 |
|
MD5 | 5daa041a4a7afda39868a215a2351535 |
|
BLAKE2b-256 | 3d5cbf041a7eb12e41aeb2a8fa1dba8208f9d50b876290937bee8bab7a7060c5 |
Hashes for oracledb-2.1.1-cp38-cp38-macosx_11_0_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2611a9bd530829ba2332db8a7083699579263cf3fb1093b0e1f5b5a57239e18e |
|
MD5 | 41d7fe37182bc79cfff06d910444dc1e |
|
BLAKE2b-256 | 30bc5bb96ae85d30efeb5d8f6aa2c2449281abfd8187044658c2d6e743d3a423 |
Hashes for oracledb-2.1.1-cp37-cp37m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ec05d1a56e9f45741ed60e7c24a8c9cc0f1982241aa555d57b04ed0879b59228 |
|
MD5 | 34fa6bf4dc36b811fcccd6413423bf90 |
|
BLAKE2b-256 | ae2e587bd18d8cca198e5b81ccfca570ff5e06d7286613a4e71b2a84d916e6ff |
Hashes for oracledb-2.1.1-cp37-cp37m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7262457d256c30a738cf3dde4ec175d2d382c6c7b9e3395665c04c25b34d28b0 |
|
MD5 | fde5296705146b7a08c30da49125e0af |
|
BLAKE2b-256 | 53afd7ae3f3e194da33a7380966108666cddd3833fa14a19c98aa2918ad2b321 |
Hashes for oracledb-2.1.1-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0750de1b381f6d3508904e079491a99d61742db109131dc664d4b3d146ee6f17 |
|
MD5 | 2e5e3c6e6df5effd9a278dca75827a35 |
|
BLAKE2b-256 | e0681c40dc471071ca024a2d35b995eaab4cf4ce76d8ede6993157a98127f1dd |
Hashes for oracledb-2.1.1-cp37-cp37m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | cc53191a389a2b6119488635c63e626e76df3394403d0e907260de9ad01c0a6c |
|
MD5 | 7d4be18cf526daba6eeb5ad099bef788 |
|
BLAKE2b-256 | 4dbf29fe8181da36760c88b4ae194edb70de886b739e491d40bf83efe03baf2e |
Hashes for oracledb-2.1.1-cp37-cp37m-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 48057c0309d2e5f4b78804bd73b4e32654ff912515da17163262142a5f451e0e |
|
MD5 | d97eff7e485bb306762c5d32eaa1e31a |
|
BLAKE2b-256 | eff57ba45676b09aeb9b0b764acf5cbbc871a738b8b70e6b76318fa0bf613582 |