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.1-cp312-cp312-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 08827b11a8a5e6485b1f694714550c856db8f288b85f0e0c9a5a2bbbde1a92ae |
|
MD5 | c0fd1deb9e8dd4bee92a31302aa0b7de |
|
BLAKE2b-256 | 5d7f717c341f6949dd1e689ac732bfc20be7049e3feda39b61e2a462be7c428b |
Hashes for oracledb-2.0.1-cp312-cp312-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a64690c6efef0ebe04684ce893a116357b02c269e1ae88653165ac04bbcb5a8a |
|
MD5 | 7be81ad66407943b3fcd9db49361d5a1 |
|
BLAKE2b-256 | 6c31204019295b83e7bb7db18ebee702ed5f1dc59c7e8cc106e5fc52a83147ae |
Hashes for oracledb-2.0.1-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3338e31fa946b84baf1ae675cb9ab242464dd072cbafc7e885a1b1130215fa9d |
|
MD5 | 0a4b28916cdb0903234cc6c92f62992b |
|
BLAKE2b-256 | 32f22e57f0e06edbf62ace52526f6896c64b6b61fce0b9b0a81c85a7eff116df |
Hashes for oracledb-2.0.1-cp312-cp312-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6c7cc2c51ed0657f6bda23002e7e407c4c971c9c5d90baa073d78b056e77672d |
|
MD5 | 9bf45fe64fa16e0e8e6b026e68e5fafc |
|
BLAKE2b-256 | 21d4577fd8af20f2eab2926148604a63cb608389b1de83b8bd592d8d3f9155bf |
Hashes for oracledb-2.0.1-cp312-cp312-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4fcd5f3127cd833939dfccc615c0ae328535feba3c66765d8308e2bbdecda5dd |
|
MD5 | 03b18ee0d03ea92537fba0bb25a8d950 |
|
BLAKE2b-256 | b67f7b36742209dd77308cf5282446c60ca42cc0c831c165fc61fb704a05d09b |
Hashes for oracledb-2.0.1-cp311-cp311-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b301f68bf1f4e79e7b1b00dc070853b3256f00dea503f80ce7d22cba5f6559f4 |
|
MD5 | fe8b50d20fdcde0bb6aca0fe176ce3b4 |
|
BLAKE2b-256 | 2a5cb6928785a2f84b4b5c1887fffb5821bb7fa1d13cc55151d9695c97b9da4e |
Hashes for oracledb-2.0.1-cp311-cp311-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4b8a23bcd94a790f92680ae44f877ba8e01626c9deb41e9f788a1ef788ff2ca8 |
|
MD5 | c56ea3026cdf99e6ec56e3d9c4bc8d30 |
|
BLAKE2b-256 | 9d8efa3be72bc36f31ab2f0aa9079f1aea204be5a6c27a08cac31c89906178f2 |
Hashes for oracledb-2.0.1-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1d504cc4ee4d2c511ca3185ef8ebf04a538d749fc30d4cc59843a6cff5d11df6 |
|
MD5 | 7030c61b8e2d1a3846fdfeeb7d8998c9 |
|
BLAKE2b-256 | 3bbe0932cd0b6ac815a0760cbfcab1defc4313a30395355018797b8da51eb3ca |
Hashes for oracledb-2.0.1-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 465389b3f9b54edcb364d66d848b048982beaaa4a24ff9a23b29582e5ac33dc9 |
|
MD5 | 447107215c770d266125d9fb71d7f895 |
|
BLAKE2b-256 | 23330eb503804de1480ad84aa481548e9494dd47bba7a712c3f692142d50cf2b |
Hashes for oracledb-2.0.1-cp311-cp311-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 903a51550ad339d475fd1cd77059157687608fc5da3af3641728c0baada5aa06 |
|
MD5 | 0d3d713d1b73ba0cdf086e1cbd0654ac |
|
BLAKE2b-256 | 57d2dfef4d869f68d9f81c6b3e172d058c70b75e4e2a18d7d7ef73022afd4f51 |
Hashes for oracledb-2.0.1-cp310-cp310-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 608a7baf1adb952848e1534dab59aa3b1b7bf3771e6940d042b40826f2747aaf |
|
MD5 | 1ceb526b4d4bc34ced9e0715c66795f1 |
|
BLAKE2b-256 | 4c244802d69c661644b773ba9ab4d66e9b9fe86a7c328378e58151164d5093a3 |
Hashes for oracledb-2.0.1-cp310-cp310-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b82d92c3c25550033bf41263f30fa9c775bd35b5e57d95b5d2a4d4ae83e456c6 |
|
MD5 | d68721e5e7540d55bdb3d52fff328942 |
|
BLAKE2b-256 | 388b9dd5169e6840724983b679fde12fd334f760cbbf605cb77bed20a079de1e |
Hashes for oracledb-2.0.1-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f77566314fc2a2da6022d9bbb769c0d08724c6b321ce0bae73b627d65639cccc |
|
MD5 | b55f70f3f2ad99e3dcf7d98d05ea606b |
|
BLAKE2b-256 | debd9247579bbcfc947d0239c143603d4cc859e6e3ca7a7d8bd2325ace8de0f4 |
Hashes for oracledb-2.0.1-cp310-cp310-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d1b68a09ead904982f260bdb1c9f1565777f0d8893e95599a460068d2824d9a6 |
|
MD5 | ae26fa3c096e46a67adf3f2757d2e723 |
|
BLAKE2b-256 | 2a8a8369174eda3b39d51a0d2e01506b973e18ceadb774451d09203f3070a801 |
Hashes for oracledb-2.0.1-cp310-cp310-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | deff10e6fd97cc6f6fa9bc94ebcc3875a38fbcfd1de5ce4c372658ff82d5037b |
|
MD5 | a090aff44e30d81f7a1f89bf8ace18c4 |
|
BLAKE2b-256 | a24ede89132c744ba5dbc94430dc609afec60da4f12b9289d59194e779a7b042 |
Hashes for oracledb-2.0.1-cp39-cp39-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 20c4bfff62df2198f99c5fc58c8df6ef934f5583875e5ab43bf6438b920f0cba |
|
MD5 | 1cbbbe9b2b5f5fdd0d5ed4a461f34951 |
|
BLAKE2b-256 | 510ec1e022f2373b61fff6df5f8f42222fc0cc510bd477aa2663caa1aef602ab |
Hashes for oracledb-2.0.1-cp39-cp39-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | bb5dda68fb8ca7c817d2b70f3fdc38cfca1f635e35850ffb282f44c86885a22d |
|
MD5 | a5339f7ce54a82d95394c84454ec7cb5 |
|
BLAKE2b-256 | 95647ec52d43705f3187a5af5103b74136dccd0899f36d805dcc60f9b3e2439d |
Hashes for oracledb-2.0.1-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9f05c7a5285c06a2acd55ed60aa24bd1adb931686f56684847672c9cef7dfec3 |
|
MD5 | 393f0d8276b2745f00759c389c8513a2 |
|
BLAKE2b-256 | 6d0afc7f97d314cc82ab14cf23b5324a1fc3f4b32d3505ccb5b8ee6f3427fd52 |
Hashes for oracledb-2.0.1-cp39-cp39-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9b555d1da8ac6a0922e66127b1ed424f6814d9789b1551df0d6d37df8d006e79 |
|
MD5 | ef6681cd0329a24c5a8586b24ef76ea5 |
|
BLAKE2b-256 | a4880dc6df30e88b4ecf067532656e41e6b04e35693fa53e9f59da39b0e5d321 |
Hashes for oracledb-2.0.1-cp39-cp39-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4f1d99ed802131197b21b011bdbf90f418ff7fac95daf2419c79dd6355c469b5 |
|
MD5 | aa27f059b84312fed651af5beebebf7b |
|
BLAKE2b-256 | 413d57adbe44ccf0fdfddef88044f8fc84a828847425fde1b4fa033692621f1a |
Hashes for oracledb-2.0.1-cp38-cp38-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ba7c086d17852564c3e906ce5f285e97d3da261672febfc83e4a8d5882795ae8 |
|
MD5 | 1d5ae74d1336cc0e0acd65a29d33efb7 |
|
BLAKE2b-256 | e0c01f7aca78b04023ea5dccbcde148dbdc09f96592af463478ec81767711387 |
Hashes for oracledb-2.0.1-cp38-cp38-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | bd3d2f8ec54d741b74aaa551d127d25a6bbd01351736dc2645ed0d2c6b3f828e |
|
MD5 | 5ce062fb5fb628090a7123cf337d9696 |
|
BLAKE2b-256 | 92dc867bf354e97f747f9b2331b3173f72f372d5d6dd55c6b137868c956174b7 |
Hashes for oracledb-2.0.1-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | bf901522ee069fe6a44c32864b1b42016613b78f7acfddd2075d0d3f117ac6f7 |
|
MD5 | 78be8c8863c501576a063340cc2916f7 |
|
BLAKE2b-256 | fc20fff1e4469c94213047a39d2091f790043a14a999aa688daeee1cb85868bc |
Hashes for oracledb-2.0.1-cp38-cp38-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6b89b812e79ddfd670b0147717b3c1c8da1f2b967c5d2bc6dd8ce96f6ffef214 |
|
MD5 | b46c501d35c75634e8cb0e4531798f77 |
|
BLAKE2b-256 | c9ef2f61271266710b8be227d5a36b555d495957de4dac8ebfbe62420e327a51 |
Hashes for oracledb-2.0.1-cp38-cp38-macosx_11_0_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b646b8bcacb1163a64646922965060131982641d704396585ed5f663329e3a0e |
|
MD5 | 9703d816fd6ebc61b87734eb7a858892 |
|
BLAKE2b-256 | 6adaa7c773300bfdb6dad984d8bb89efb01d123162367637dcc69b8c56657212 |
Hashes for oracledb-2.0.1-cp37-cp37m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 45eaf9eb0d7c27ba9b1cfb09c86ffefeeffa82d90dc3ad910725623a11495e1e |
|
MD5 | 48eb3157925c5bb089a29b3a9f7e9f88 |
|
BLAKE2b-256 | db576bbfa48d0d9d476d83baddfe0554a37d2a8f5be8efde70c93d525c00ffe8 |
Hashes for oracledb-2.0.1-cp37-cp37m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1dd8a0f39cb62b33a6bba2b601435522ee42ad5a526db3d2f858b671bf87d956 |
|
MD5 | 9074a2cc1787e16d18b0cff0c427eb5b |
|
BLAKE2b-256 | d0fc12f21f0feaeb3ea0ffba32310d75bc9b3cc59eb71ade6e398d25dc92c5b3 |
Hashes for oracledb-2.0.1-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 805d1d736ca137427521499f9a58ccfe981a1ccbb9be5cabc2e204dee7700790 |
|
MD5 | c5b22f9dcaa307ac88e707bcde813894 |
|
BLAKE2b-256 | 12611b6e01b588763edae2d72e4d9dc4cf21f36e7bd41c99062a6a8bf26a595e |
Hashes for oracledb-2.0.1-cp37-cp37m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3840ceecb83dc55c8e03d3f559eb0a640cf06a7584f30cb760ba580fdbfa3501 |
|
MD5 | 4a75dd64e60275207c9e566ba02c3fcc |
|
BLAKE2b-256 | a1f97379817bd677d0a4ad342c82d51cd1718a9490531c5b16c662f4ecef3abd |
Hashes for oracledb-2.0.1-cp37-cp37m-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 73f90d6ea1a3b9b26457ecd380541fe97216867b5c757e3d66f047aa2c0e94e7 |
|
MD5 | 6ac8918201f78fa5ad063c3c77c6975e |
|
BLAKE2b-256 | 4b9c3d5d913bbb1e8c4fbd5a0f94e276fe6bbadc85b9433142708617bcec116b |