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.0-cp312-cp312-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4c4c35ed7a1cd25c7b359d838776042cd187c69f66deeb4f14221653e781d8ba |
|
MD5 | 6861181c1a691967f7e21bc7f8e2a73c |
|
BLAKE2b-256 | d306ff5309d7c2fbba182a523b0e26316547fbfd1fb0165a61768c6783cbfbbc |
Hashes for oracledb-2.1.0-cp312-cp312-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 02a3f3ca90459c6e58d50049b4b45a7fce2edd1b2267926a742ce0bfa2143641 |
|
MD5 | 536628fd2a7df85ca3984164b5ff5a8f |
|
BLAKE2b-256 | bbeebdd5d5de0db0e21b2e99c0e891600f7a9bc1b2576f6cf267506ce7c68854 |
Hashes for oracledb-2.1.0-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b30d4d240fd6c415ff29241de932145934a0cdc7a21e1266b8844ba42cf8fff1 |
|
MD5 | 12f939ed9d80fe6ae68d9eaf42accebe |
|
BLAKE2b-256 | 90aa886ef1558a29a1c620c42484ea58f969a778eff6a264724eb96b85229ac0 |
Hashes for oracledb-2.1.0-cp312-cp312-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1febe148aba2df3feb2ae9b0232ac9f90377516722dcaab2ffc3ca46d04a69d9 |
|
MD5 | 73be73b93677ddafbdb0fde3d158ca2b |
|
BLAKE2b-256 | ca3db303c07e01d419180cf0743817fbe2e032010fe37ac22bf2227e540e5658 |
Hashes for oracledb-2.1.0-cp312-cp312-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 54eb709f53be6b34c2d8db1d1601df6bdab4338ea19ee256fc1f06bbe34f7f4f |
|
MD5 | 0b71f59cc052914c0e0b149926bd83c0 |
|
BLAKE2b-256 | ded2195405558d158ce2cdb7a5522d3939aa05397931adb46662e85d0f773ec6 |
Hashes for oracledb-2.1.0-cp311-cp311-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 69dabc4629b8f97d2caea448507dcce169648aa1b9063c76f0aed9d7e2784fed |
|
MD5 | 8702d12594f88c0ce35f070ba76041f1 |
|
BLAKE2b-256 | 329806c517cf9595b03fb8a975d9c3c85616b50e04d6c4750013ccce8060b364 |
Hashes for oracledb-2.1.0-cp311-cp311-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e31e0093f1a1c5cc05de2dbbcb14f493256cb254566ef749baca80a8f7a5d116 |
|
MD5 | 8c09bde92ccd7f5860ad12c487202ceb |
|
BLAKE2b-256 | dd8ea9060070e1f26816b20ab7b0d28b160eb386e60573bd50c071b37940d26f |
Hashes for oracledb-2.1.0-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e6cf81c362d00cee9957a86155732b9d5dd5e2fa4b6062a6ea5a51655fc4ff7c |
|
MD5 | 24f4e7de2a9c2ca54c4779c4eb5c91d3 |
|
BLAKE2b-256 | a925464472ba25e40c3a74df1cff56f73f9bd7954a72bfd5cf71028efe6b7cd5 |
Hashes for oracledb-2.1.0-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 881f46da2a3a2712651277fbf2c3cf810218469aa8bb7ca34743ab1b496baa6d |
|
MD5 | 1198498915faf3c581f898b5e3994990 |
|
BLAKE2b-256 | 169e544b06729b6d18f9dfbcc96ada9bf30348a5b588d2846a175cb1aa1c470e |
Hashes for oracledb-2.1.0-cp311-cp311-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8753b1d354d6b1357f0fcf3820289fb63a73ad8fa6501130f2536dd36f4d866d |
|
MD5 | 2b4860e9edd61dc432cddabeda2b3b02 |
|
BLAKE2b-256 | 3b29e1433f698344e6ed413a598a03259656029a92a1cf60f216922fb11ec645 |
Hashes for oracledb-2.1.0-cp310-cp310-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 675bbd68ff5da0252914d603508040ecde6b22ab658be0eecd2bb66a5b5dd0fc |
|
MD5 | 7af3a022d73793a1c863417363f97ae0 |
|
BLAKE2b-256 | c6bd0b2b27e90f9674e971640c43e3a62c4c0954f6b888cd2de94eef64a98878 |
Hashes for oracledb-2.1.0-cp310-cp310-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9669b2586558f49d9015ddebd416141e7b16d20e769194887f4c5f638449fb5a |
|
MD5 | 1823c003843435128048747fe567ea2a |
|
BLAKE2b-256 | e154b50006f61ed04989e13c5a7999e7755d1b2b0e0621f72f747bf52ea9ae8f |
Hashes for oracledb-2.1.0-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1fcb2fdc8b5ee81855ed0f83338d05941dd1bd3e7dafab57c9bf14a62a102225 |
|
MD5 | 4fd4cf0f7dbe3a68ff1b5121556f5c66 |
|
BLAKE2b-256 | 8f47ee4c47e8dca3ce9921e26ea90233747bba783f6403cb815887f7e42a008c |
Hashes for oracledb-2.1.0-cp310-cp310-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c38c3d011e2a14ee4fcf73a7ce677e86787bd814cd677d108c0d45d8144cbb9b |
|
MD5 | 4822fef06a98b838bb6cfc7d7bdcc962 |
|
BLAKE2b-256 | 5b3808f3e6ffd24bc43e97cee96ed06152d79863a0f72842a7fbe95753849844 |
Hashes for oracledb-2.1.0-cp310-cp310-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f145c1e8f52e4927f113656b5b15824c1e79ebac68e934f9997d2c595d371b3b |
|
MD5 | d5c41b5dc87997bcf5b6e1535ccaf773 |
|
BLAKE2b-256 | d0fbaf55a13539f845da45a51670cc1e888b67e343885aca513056d92abd09e3 |
Hashes for oracledb-2.1.0-cp39-cp39-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0193975d819338e12f5faa59e8ca0954cf2f3261c375d01b7096716cd7134847 |
|
MD5 | c5d3704baf5566e9e00484dfb71e2024 |
|
BLAKE2b-256 | 8e393616f7d9c8777b744092204310acf2436d9680390e50e8919c0e4b18ba1a |
Hashes for oracledb-2.1.0-cp39-cp39-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5a57b3562c5ce50c4b8366b88eb35a70eb74de0f8fbd87665fbc891dae7cfbb8 |
|
MD5 | e17c95670e3a2eb76916245ec6dfe2dc |
|
BLAKE2b-256 | 69889cee9cc76a61a1461597a13a3b6f1f826b52d1c1ca36ba7ee4c8f15bc41d |
Hashes for oracledb-2.1.0-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5d1a5a258011495b9e979773f1c9a81a100f2c8892f182bf0ad58218769ecafb |
|
MD5 | c61c4901fa337306aac643a15d9c2cee |
|
BLAKE2b-256 | 9b9cca21d86dfddad6e435e5d9c387306e8e2757d5225241faa08cedb750e0b1 |
Hashes for oracledb-2.1.0-cp39-cp39-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | fcda142549766bbe75121459bd1366f75e8627e031adf80f71f706f4a482b870 |
|
MD5 | c1bb158b9dad1c2cbed182aeabe2ec5c |
|
BLAKE2b-256 | c6d4f2c2b7f68b3a8727daa5e25fc13e907171354a7cf7804e4c5fe9b6b119e4 |
Hashes for oracledb-2.1.0-cp39-cp39-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0216d02856e12b085c259537d5b0d0a8ef6280041023d4ef36fc03363301c869 |
|
MD5 | 49702e3b8831b21d17210100cfb65738 |
|
BLAKE2b-256 | f876e905555e629c9711fcebfd9c20355900ed1cebf54b71e6ddc7c8522580a3 |
Hashes for oracledb-2.1.0-cp38-cp38-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ce8c9f4ed0818e3fa7938e1d41b6a48aed909c64c6fdd27fcbf5cad2cd78fce2 |
|
MD5 | a371e88f85b76205d6923ee6eb354db7 |
|
BLAKE2b-256 | 582a5e752eae58e16b55c91c7b091c82a63b6e3bc7fc918db69ba0828186aba6 |
Hashes for oracledb-2.1.0-cp38-cp38-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 979ecb21e6327ba20522bf945a489fbf687ead89062c90feeae8cc1c7bd1a303 |
|
MD5 | f14b6219ca2dd1078dd955b274c59cf7 |
|
BLAKE2b-256 | 6ed607bb6720e3ef15bae37e456fce7e2f6d923e7b257a4f67d3fa0843a1a6bb |
Hashes for oracledb-2.1.0-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c2cc26adc2d3233b8642eb2785ba6e480e321a48b5587fd89707b9de38681d4b |
|
MD5 | 68ef0d228229c9e35ba7d19ff469d84e |
|
BLAKE2b-256 | 81906490988a64dbc75c5863e4ebd862a34c65ad6e3e82c944b3744dd36ccc91 |
Hashes for oracledb-2.1.0-cp38-cp38-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 50a8c2f3a54b1bd58c1dd9b9e4c38cc919cdd7378e514840bf64d489940497fc |
|
MD5 | 4dc32ac85c26a042d88792c41bc1c6c2 |
|
BLAKE2b-256 | fac40e5a11a0f7d7e267195b354e17ae40c5bedf1eb8ab0a5a8119511ba966fe |
Hashes for oracledb-2.1.0-cp38-cp38-macosx_11_0_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 094a245b03d717bc88c1c53436cf51ce4465cf61fa2878529b4a565d372e25d1 |
|
MD5 | c62357b571f273a86a2fac52a943c5c8 |
|
BLAKE2b-256 | 4e602452d94168f12967c51ed2d634cad4ce095be0b4885240fc25d29c99b92a |
Hashes for oracledb-2.1.0-cp37-cp37m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4e1363a1ec0cbdbaa39f647ae5fa2954c99be8d8bfa88b089043e8356988e4c7 |
|
MD5 | e4a7a1eb7f244b638f4ebb88b739e566 |
|
BLAKE2b-256 | 8e1ddd90d7b380f139ec6a0154fc7e6fdc13dde9ac653e33896f108c0c000814 |
Hashes for oracledb-2.1.0-cp37-cp37m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | da8ae2c8f0dea162056a1fa6ba0c276c989f1f3501dba1733bbb9b2c09aef112 |
|
MD5 | a800233d2cf34dd9cada800d218ba174 |
|
BLAKE2b-256 | e5322898302852bada3fe5aa54a7e16dcc90377cc9399093f7acb3bdf13cb726 |
Hashes for oracledb-2.1.0-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5bfa66262b97a44a16f9d0545d3cb6e191c0c53e8f5a2fb85a77b62169618aaf |
|
MD5 | 6e5bc6be13d633ae7cb70cfa7a4cb2a5 |
|
BLAKE2b-256 | a064bcca0004903326b027c4eed84e985568657dc45b1a0a1466c94cab176d5b |
Hashes for oracledb-2.1.0-cp37-cp37m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | dde4d4fe94232849ccd8093d026eecaaf12fd0f63c7c1df8fe55a87962db6aec |
|
MD5 | 388ad283d6184e7744834167bc396989 |
|
BLAKE2b-256 | 1f3e22b205000eda0f7b79e6044b266063f9b4f1d8cdafe9c6ae073073e99040 |
Hashes for oracledb-2.1.0-cp37-cp37m-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 29936ea16a0b35efe3ec914e523bb8025969ecae7247a5cd69176aafcd6dd979 |
|
MD5 | 276004802c03181a1b384a9908378c59 |
|
BLAKE2b-256 | a32f872821ff1ee3c04a26006a9016fe264a5a0277e57b424aca6501c7e8acce |