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.2.1-cp312-cp312-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 470136add32f0d0084225c793f12a52b61b52c3dc00c9cd388ec6a3db3a7643e |
|
MD5 | daa4d55e0d2bd3b986eef6ae5221ba56 |
|
BLAKE2b-256 | e625759eb2143134513382e66d874c4aacfd691dec3fef7141170cfa6c1b154f |
Hashes for oracledb-2.2.1-cp312-cp312-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 44a960f8bbb0711af222e0a9690e037b6a2a382e0559ae8eeb9cfafe26c7a3bc |
|
MD5 | daf75a847c8571e942b37bf91f59b9b6 |
|
BLAKE2b-256 | 3be2005f66ae919c6f7c73e06863256cf43aa844330e2dc61a5f9779ae44a801 |
Hashes for oracledb-2.2.1-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 193e1888411bc21187ade4b16b76820bd1e8f216e25602f6cd0a97d45723c1dc |
|
MD5 | ab64996e319bcd5dc13cc27a9604adb7 |
|
BLAKE2b-256 | 9d58bac788f18c21f727955652fe238de2d24a12c2b455ed4db18a6d23ff781e |
Hashes for oracledb-2.2.1-cp312-cp312-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c150bddb882b7c73fb462aa2d698744da76c363e404570ed11d05b65811d96c3 |
|
MD5 | 33ecaf2df0013a2a9f1386b84ba64ca3 |
|
BLAKE2b-256 | e68834117ae830e7338af7c0481f1c0fc6eda44d558e12f9203b45b491e53071 |
Hashes for oracledb-2.2.1-cp312-cp312-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ac5716bc9a48247fdf563f5f4ec097f5c9f074a60fd130cdfe16699208ca29b5 |
|
MD5 | 6b74f1f8a688c665de2f1aa006492031 |
|
BLAKE2b-256 | 245b2fff762243030f31a6b1561fc8eeb142e69ba6ebd3e7fbe4a2c82f0eb6f0 |
Hashes for oracledb-2.2.1-cp311-cp311-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5134dccb5a11bc755abf02fd49be6dc8141dfcae4b650b55d40509323d00b5c2 |
|
MD5 | d2c75ff8590aebefd90a23cd2e22e696 |
|
BLAKE2b-256 | e3b8b2a8f0607be17f58ec6689ad5fd15c2956f4996c64547325e96439570edf |
Hashes for oracledb-2.2.1-cp311-cp311-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | fec5318d1e0ada7e4674574cb6c8d1665398e8b9c02982279107212f05df1660 |
|
MD5 | dd0f769feeefd61b243b95296df281db |
|
BLAKE2b-256 | 4d1a67814439a4e24df83281a72cb0ba433d6b74e1bff52a9975b87a725bcba5 |
Hashes for oracledb-2.2.1-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 63daec72f853c47179e98493e9b732909d96d495bdceb521c5973a3940d28142 |
|
MD5 | 577cd3d945ee3abb6d19eb5455240196 |
|
BLAKE2b-256 | e95406b2540286e2b63f60877d6f3c6c40747e216b6eeda0756260e194897076 |
Hashes for oracledb-2.2.1-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 07757c240afbb4f28112a6affc2c5e4e34b8a92e5bb9af81a40fba398da2b028 |
|
MD5 | 686bcfebca8cb504af024e7fdc843795 |
|
BLAKE2b-256 | 4f5f98481d44976cd2b3086361f2d50026066b24090b0e6cd1f2a12c824e9717 |
Hashes for oracledb-2.2.1-cp311-cp311-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | fb6d9a4d7400398b22edb9431334f9add884dec9877fd9c4ae531e1ccc6ee1fd |
|
MD5 | e8d319a771c41c5f9efa46f1ee918347 |
|
BLAKE2b-256 | 74b7a4238295944670fb8cc50a8cc082e0af5a0440bfb1c2bac2b18429c0a579 |
Hashes for oracledb-2.2.1-cp310-cp310-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 708edcaddfefa1f58a75f72df2ea0d39980ae126db85ea59a4c83eab40b5f61e |
|
MD5 | d9dffd201239216ed9dccfcf82ee7a48 |
|
BLAKE2b-256 | 8813f16883f374bdafc748b741b7e1b0aae9944bd2306e222ab6358061574a5b |
Hashes for oracledb-2.2.1-cp310-cp310-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9bbd2c33a97a91d92178d6c4ffa8676b0da80b9fd1329a5e6a09e01b8b2472b5 |
|
MD5 | 33ca8ce01f66352c2c89b6c80703c69f |
|
BLAKE2b-256 | f35691a1cf51e04ab796945bb0916358efca44ec9f115dfd14c62eaa015ed76a |
Hashes for oracledb-2.2.1-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 531600569febef29806f058d0f0900127356caccba47785d7ec0fca4714af132 |
|
MD5 | ae615bd72e644c289059dcab3a1513cf |
|
BLAKE2b-256 | 3c18e9c13dc615f27735451456a81ba206dff68fc563629941ec6cd873370a8e |
Hashes for oracledb-2.2.1-cp310-cp310-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | cd8fdc93a65ae2e1c934a0e3e64cb01997ba004c48a986a37583f670dd344802 |
|
MD5 | 1bc54779649099b060d3044e28da502c |
|
BLAKE2b-256 | 1f6c11b59ca844ecb016ea145033cb8958195d8d18ed6196215bec60020671b4 |
Hashes for oracledb-2.2.1-cp310-cp310-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3dacef7c4dd3fca94728f05336076e063450bb57ea569e8dd67fae960aaf537e |
|
MD5 | c0194eda2f3e1ff7003a20e86d6307f7 |
|
BLAKE2b-256 | b7585097a63e68dbe92ad4cbd2f18f2217b3ab1bdf5900545b42c4e5f790fbe8 |
Hashes for oracledb-2.2.1-cp39-cp39-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9e76d46d8260e33442cac259278885adf90080f7d2117eaeb4b230504827860b |
|
MD5 | 1f9ad40b9e0dc112e5ea23c5cd00a712 |
|
BLAKE2b-256 | 13e519ba3f3125ebf46baee6cbcb0aebebf552c49deeaf3cee404af11d5f1554 |
Hashes for oracledb-2.2.1-cp39-cp39-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 49a16ccc64c52a83c9db40095d01b0f2ee7f8a20cb105c82ffc2f57151553cfd |
|
MD5 | cd826370915e13d8926c9e49fc6e359a |
|
BLAKE2b-256 | 2cfc5f2bdcfe4abe19ad51ba7c5a1e91d4fe10b8f7864e47c063001634dec326 |
Hashes for oracledb-2.2.1-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0048148630b60fe42e598591be152bd863ef339dff1c3785b121313b94856223 |
|
MD5 | 381eb53551b1f1925ec11f147f59954c |
|
BLAKE2b-256 | adfc091b4dc30b57be17b39562ff92e9b91a004608c43ab141874c3072986a3b |
Hashes for oracledb-2.2.1-cp39-cp39-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c7d4999820f23bb5b28097885c8d18b6d6dce47a53aa59be66bf1c865c872b17 |
|
MD5 | 758cdb06a42c57a14cc37dabb0fb04a6 |
|
BLAKE2b-256 | 34d2a8fade09b244cbd0c1e50de5fca70fc2b843c4504f8d10358bd6e6c04f23 |
Hashes for oracledb-2.2.1-cp39-cp39-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 78e64fa607b28f4de6ff4c6177ef10b8beae0b7fd43a76e78b2215defc1b73c6 |
|
MD5 | 9a9b3410a8dd669583e94abaa8116012 |
|
BLAKE2b-256 | e3827c71c647a1fcc2528126eeaeb8ecb1c417062ad4e4286d8f730832500046 |
Hashes for oracledb-2.2.1-cp38-cp38-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c1894be5800049c64cdba63f19b94bcb94c42e70f8a53d1dd2dfaa2882fa2096 |
|
MD5 | f06571ac6eac8573ee725c748324b19c |
|
BLAKE2b-256 | aaecdab4af5b1dd188e619fa3d695c0a4d0f318539d6fc2a53acf5a20018b7d1 |
Hashes for oracledb-2.2.1-cp38-cp38-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 406c1bacf8a12e993ffe148797a0eb98e62deac073195d5cfa076e78eea85c64 |
|
MD5 | f629174abc145725fa6d4dd18970baa5 |
|
BLAKE2b-256 | 553db415aa0efa46151051bc88c4c616bb6f235f69a73b52cf31b833b4e11d38 |
Hashes for oracledb-2.2.1-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9077cbbe7a2bad13e20af4276a1ef782029fc5601e9470b4b60f4bbb4144655b |
|
MD5 | ccd348c8e15d0cb4a99aeb9e95b14d22 |
|
BLAKE2b-256 | 290a4eda646134a06a3fa8fa6596428534947107044ed0f0e634da94b6d775e0 |
Hashes for oracledb-2.2.1-cp38-cp38-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 37564661ba93f5714969400fc8a57552e5ca4244d8ecc7044d29b4af4cf9a660 |
|
MD5 | 4b93cbc6f474c1f1786a9de6e1b6ec72 |
|
BLAKE2b-256 | 0aac2ce4dece6130a4ff31a4803a95491684cadee59ae8494a074f8737c70356 |
Hashes for oracledb-2.2.1-cp38-cp38-macosx_11_0_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7df0bebc28488655fbf64b9222d9a14e5ecd13254b426ef75da7adc80cbc18d9 |
|
MD5 | bf94b92c7dcc34a76ec4e7b2121969be |
|
BLAKE2b-256 | 40de6e399a39d5e05595bc97f4b00bb3e3105c28449a72f99872a2cb242cb75f |
Hashes for oracledb-2.2.1-cp37-cp37m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6af95303446966c808f3a6c1c33cb0343e9bf8ec57841cc804de0eb1bfa337b5 |
|
MD5 | 23e288f75f93083caba4b69eb78cb521 |
|
BLAKE2b-256 | a60be007c68ba673111b81e9d0cd5b08a9c62952b17007cd746bffa77f6f7aef |
Hashes for oracledb-2.2.1-cp37-cp37m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4b433ea6465de03315bf7c121ad9272b4eef0ecaf235d1743b06557ee587bf6e |
|
MD5 | 44801c9df358feae45596776d494fe4d |
|
BLAKE2b-256 | 710eac2b79a60bdaa6859e12f6916be1fcb694a707c4cd5f4aaad5e732bc780c |
Hashes for oracledb-2.2.1-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9a47019561c5cd76d1f19b3a528a98285dca9d915dd8559555f3074424ee9438 |
|
MD5 | aea594c82507f2e92cecd8ad7b98df4a |
|
BLAKE2b-256 | 6f94fb3ec80b9a13a3d6163865106a92e2e99a1a913adbdf3a19a816869bf098 |
Hashes for oracledb-2.2.1-cp37-cp37m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f5b8b46e6579eaca3b1436fa57bd666ad041d7f4dd3f9237f21d132cc8b52c04 |
|
MD5 | 4585b1ad70130c7faef631ef19721c25 |
|
BLAKE2b-256 | 83311af797e42a21d76357fce43843a6fe19a5b824f6010146ef05f560f9bb2f |
Hashes for oracledb-2.2.1-cp37-cp37m-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 506f0027a2c4b6e33b8aabaebd00e4e31cc85134aa82fd855f4817917cfc9d5e |
|
MD5 | a93bd3a6ee18282d41d0a7ca9247b70a |
|
BLAKE2b-256 | 3f3b393b20f547b3daab8bbddc9c8f46e9614e3bdbb68bd17d4aa891b9531336 |