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.0.0-cp312-cp312-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | fa151acf5d47cbd1129d857196fde652a5b4c95011d7b79037111b11f36e704f |
|
MD5 | 2323be63503cb26e30b9900234eaad4d |
|
BLAKE2b-256 | 2c8100aea8479bf73d92a74f4d5518132f47a64a7468a8c4c3adafd7fb3e4fa7 |
Hashes for oracledb-2.0.0-cp312-cp312-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3d9706346e8074d7f5bc037609524285b472b33ef30ea93d49715d50c32a1deb |
|
MD5 | 562d9f12c517cd836bc023369a53a76b |
|
BLAKE2b-256 | 4ca86cf8aaeee701d94ebcc44a9d53621ddd07aac74c7febb238e48d69fe4f46 |
Hashes for oracledb-2.0.0-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0607557008bc76bba372694ffab6333ceea078ccb6bacb60aad8409e0b74b80a |
|
MD5 | 194bd7c16b074fa445d7c47c5a13ccbc |
|
BLAKE2b-256 | 007b52080b70fca9d35df6cc07d32fd1ff39d825a66cb2f9839d40aef763dbb9 |
Hashes for oracledb-2.0.0-cp312-cp312-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ee5d7967ab4043678d078a42ae2920527993d177f5c9c16f69f64cc9c0e8ab71 |
|
MD5 | c26f8bd4456b1cbf1db66bd319f95587 |
|
BLAKE2b-256 | 5a8ecc31fce63155bad3964cc66d01a0d56ce72c206da19fb35bbdb02dfd43a6 |
Hashes for oracledb-2.0.0-cp312-cp312-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8c4f5a7ceec2e2a3584bbd8853285ebfd5382c5514df3d52323ac014816bf398 |
|
MD5 | a90ee651a43f64a20f4947220e9c020c |
|
BLAKE2b-256 | 205153c41ddb9dd8f74186836f5832080aaa0d10ecacc5a0350e2a48bd151693 |
Hashes for oracledb-2.0.0-cp311-cp311-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b5821533e5a881abeaa107115474baa832315ce3bca1609c535d121e3266d226 |
|
MD5 | 810aec5ecd7b4e6e51ea442648c9e5ff |
|
BLAKE2b-256 | 928c34bc04d156853c41d2c7493326342797001958c9a9140d97431470ff6b6a |
Hashes for oracledb-2.0.0-cp311-cp311-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 741766325c2738171a86e667e34f87e39c6ad1c62d361743e399e5ced6c86d88 |
|
MD5 | b5ba750130754e7ae62a174afefa3620 |
|
BLAKE2b-256 | 24edd1377c9ba38e0e0173ab8859161e0b97108c511959fc02886577f7b01c00 |
Hashes for oracledb-2.0.0-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 33b8ee18558e5e7e79bab2d09f62095fd637781a41d3bcbc5eb3fa93d4a20285 |
|
MD5 | 05cf1419d26acd8c00f6943f35d1a1a0 |
|
BLAKE2b-256 | f4234f781d91958dab7284b3d73b18a47421bd72898b009c842db6dc7b94ef6a |
Hashes for oracledb-2.0.0-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e315bec42a839ccd545553de693cffa32178eb54e30578c8cf568de1302aa399 |
|
MD5 | a0f689d4dcc1d98a59b9adde00109c2e |
|
BLAKE2b-256 | 770d9535cc0a87cd5754d7e2d810023560a7347bd2680b0a0f6ac33481c3dab4 |
Hashes for oracledb-2.0.0-cp311-cp311-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 2ae142807e14f2f59cb138d7023e698698ad893ff90101cfc1c2f128474ae3c6 |
|
MD5 | 3c1af9c817cba49c669bf3f2f7b7ca20 |
|
BLAKE2b-256 | f95f1f3aafd0c00c248fbce1b2146cfd1ff920336f9960bfb3f8dc924260a24d |
Hashes for oracledb-2.0.0-cp310-cp310-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8faefd3ef397e8d665e8864c01a4459fb42097f0cf7089e69a1665b545bd4984 |
|
MD5 | a03d36e2de7284729a7c8c7fba9c8060 |
|
BLAKE2b-256 | c57a0e9c4f1c152362b163ffb1bfdca9fe698549c0e6e5cf582ff08097278765 |
Hashes for oracledb-2.0.0-cp310-cp310-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | acd1c88a21d712853cdd360ed911fa17b63e0f79eef8cad6dd9dbb04eb32ae0b |
|
MD5 | dc3cca972812665dc30809831703c2c9 |
|
BLAKE2b-256 | ec96226bec42d46a6a93d6265d3cbdc575c1b65858d8a5d56d3b1285039fdd45 |
Hashes for oracledb-2.0.0-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6d31e9b59f5b471b9cf02904d437379e9efd0a69dee5bc9b9899a7fc7695df97 |
|
MD5 | e01fc2539ea75a17e32f316dd46309fa |
|
BLAKE2b-256 | e80b2fb0faa8203e397ec1b2f08df5ba14d0bd120f509fc074cc89beb03bb3ae |
Hashes for oracledb-2.0.0-cp310-cp310-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | df356d6a076da6cb74f5ce3c13090ab0d6760ecc6babed3beadbec6403c86d5c |
|
MD5 | 85a39a445d51777297122ee44f4800c4 |
|
BLAKE2b-256 | dda6a99799e1aef56c5d323d7c69a31929aa0d5948f26242b80f48652969337b |
Hashes for oracledb-2.0.0-cp310-cp310-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 129f62fb95af22367723707e5ecf9dbf7f4a7c04f8e9ae509312ab72fa049b35 |
|
MD5 | 82e12b11647cbe9a2702fee320d61791 |
|
BLAKE2b-256 | b04ad23ccd93e735efb85d78d8277e7316319a49bd1c8917ab15d359db9611c2 |
Hashes for oracledb-2.0.0-cp39-cp39-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 32223707c2029f74f648da1e826c3ea10e04c770a91f6078115ca6177106638d |
|
MD5 | 3216d6e9e0484c19457926c2181b95f1 |
|
BLAKE2b-256 | a42544a35c9861bd712efe8aeb8f678716d1ba5f06ec266f84cef6eb925ed661 |
Hashes for oracledb-2.0.0-cp39-cp39-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 34c26a4d19c2e12bde4afd24e3fe0289c998171cfc0b0eb6bea6ddcca1529c7f |
|
MD5 | b831e5cef254523c959ec7bc8beae124 |
|
BLAKE2b-256 | 6a1e7d924f87da3a565beddd8c9ecc6c3e7a02884a2f2dc3a7827623fd0498a9 |
Hashes for oracledb-2.0.0-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4769fb134053a270210e546664a768eb7fed59e295d47d6fdf57dbe5b23f8c83 |
|
MD5 | 038c92d55130e547e315fe2e1041a0db |
|
BLAKE2b-256 | 574df03399e6058719c0f29d7472bb9dfefa2b33874733b4098bb9ef7dfdc0dc |
Hashes for oracledb-2.0.0-cp39-cp39-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5f13a4aa7dc8e116c55ed4a594884b73eae357d61379900a4d3934acc8425e15 |
|
MD5 | 769c6838ee3e9e0a55e09f3813f63dfc |
|
BLAKE2b-256 | 34fba18d98972afcf69f9af4df4c1c6d91d9c4c3a3bc0d91b5cb3020ebaed03e |
Hashes for oracledb-2.0.0-cp39-cp39-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 52b142ae57faf96048b529d668c33740d26b183b6ca4af4dd22d4e9d9c05f8a8 |
|
MD5 | 0a7a19195bad07476c66de429d1dc051 |
|
BLAKE2b-256 | 109f9234dcdabf8674fe4b59ed51bc1818e27b832bc33a156ae2d2aa5c15c992 |
Hashes for oracledb-2.0.0-cp38-cp38-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 42369b5bfbfb0fa9c24840fab6d0547e16e67eff00869a4df336312dceb1d3e6 |
|
MD5 | 4b586989630a3ee2a61f80090d69a856 |
|
BLAKE2b-256 | c40f53fd2dca8083f549abeb376d92afdde6a1df88cb6fafdc0f63496623e465 |
Hashes for oracledb-2.0.0-cp38-cp38-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 992a2baf14dd4dd7b7b04db2fa0b256d8203780a838de627b50e81411203b1f0 |
|
MD5 | b39ce77cde57fc2a23d96423c8e78850 |
|
BLAKE2b-256 | 4b674cd9707dbdb3e771388a673e0d3e9ac63075073d5ed941e797253eeb749d |
Hashes for oracledb-2.0.0-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 860e468bcf1fd263f9d646888a8ae79102fb8288c982ab4f120e843b8ee278ca |
|
MD5 | 9db924f7a32c422e004d93dc8ad6a40f |
|
BLAKE2b-256 | 6d7b196394446768e2c72d04ccb2a9b5e8321fda6da1f0d52036531c22ac2984 |
Hashes for oracledb-2.0.0-cp38-cp38-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 47b55c2fc6f4e27abed142bd7181234a7ba14d5eff7ad123ef922be6220f395e |
|
MD5 | 54e2cc6a2fdbc9e08d80c207add7d6cd |
|
BLAKE2b-256 | a83cb0cae31b19a010a85a05b62666dc90228386d2a2a169ae9a791020f0e080 |
Hashes for oracledb-2.0.0-cp38-cp38-macosx_11_0_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 765d9bd16bcbb72849c3ca6165d2b7c34b2493508e7378a4f1abc99e90967dbe |
|
MD5 | 6ac319ad1af2402d6692cd25ba073357 |
|
BLAKE2b-256 | 2e1c584d26cdef16ca15b73d30f8e2b4ae35d968ef069216166ef7c4f1a7e759 |
Hashes for oracledb-2.0.0-cp37-cp37m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 13a3676c13bb5a3881e8542ff8e7f8da53e85d7486f3e030a2a0342b2fd349b1 |
|
MD5 | a98f3e88798ca5297d3a4b8f1b10b7a8 |
|
BLAKE2b-256 | 281d40b80d63c00eb080c7d47fdd537bd927500209a111f18539b5c9fc357992 |
Hashes for oracledb-2.0.0-cp37-cp37m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 64d4ba925ce5fae0f89a1f227703b550d18635f5ff03f243a49b32368400af12 |
|
MD5 | 90b87dde576bf79900c25ffc6d056362 |
|
BLAKE2b-256 | 00f4ce9416359da2f3dcdbdc77c81fb6f831e49aec019eb56c6da7e2fd14ef9e |
Hashes for oracledb-2.0.0-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | dc5888d0a36625e9342a6fbdccc15b5687d99fe14fab856bcdc8d6b64b4af735 |
|
MD5 | 5037852f362163d1e4b7801222c6bfae |
|
BLAKE2b-256 | bc4094e58e8702e30d044a31c19213ac7ce790816deb4eb48ea0e5f1ae8f27d2 |
Hashes for oracledb-2.0.0-cp37-cp37m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | cbbb278a89396e8c5a63fe3c661cb4ff28a829954d3aae4f105e4e5ec160cc1e |
|
MD5 | 86ea27a5bfbe9b6ea28688d3c5bc1cb1 |
|
BLAKE2b-256 | 35b1a22497bf6e89e6eccc21445f36627b427190794fe2f4d86eaeacf96eaaf9 |
Hashes for oracledb-2.0.0-cp37-cp37m-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5d8ed11913dc83f3942e78775ebde0bd02945c81de2ad9f41d706f0b07855363 |
|
MD5 | 373c0126cea9630ac344e02e6229b08c |
|
BLAKE2b-256 | 335dcd3b3069622c12dc7599dc10890532f882df6058ceff3bd58844722b0455 |