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.0-cp312-cp312-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e5ca9c050e18b2b1005b40d44a2098155445836071253ee5d547c7f285fc7729 |
|
MD5 | d74a1c398a21fb5d305d11961cd055f4 |
|
BLAKE2b-256 | 2248eeca9c347022dd17af987e1e551a5cb7fd571b4af0a8b98e20a9aa9276df |
Hashes for oracledb-2.2.0-cp312-cp312-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3fe57091a1463efac692b352e99f9daeab5ab375bab2060c5caba9a3a7743c15 |
|
MD5 | 64065ce431e6b47694277ba9ac262546 |
|
BLAKE2b-256 | 836cad95783ec10ea18861624d740273f07e89a29cfd4a0ae3c704ba27a4501b |
Hashes for oracledb-2.2.0-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c6a1365d3e05ca73b638ef939f9a609fed0ae5da75d13b2cfb75601ab8b85fce |
|
MD5 | 30d203e76e52fa7c48a863e5ddc8d511 |
|
BLAKE2b-256 | 537c60480a70293e6c59bc889c310fd7d4ce21bb740b881b5261569ab9359645 |
Hashes for oracledb-2.2.0-cp312-cp312-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | fbf07e0e88c9ff1555c9301d95c69e0d48263cf7df63172043fe0a042539e687 |
|
MD5 | faf1b4982a9baa3e338a6299411a0a22 |
|
BLAKE2b-256 | c94cc2259eebe2e8523df1b71f328a402272d39882aca57a7ace91031c3eca85 |
Hashes for oracledb-2.2.0-cp312-cp312-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 10d2cd354a15e2b7e191256a0179874068fc64fa6543b2e20c9c1c38f0dd0839 |
|
MD5 | 86c1c7ef93675697fe5fa5301668b92a |
|
BLAKE2b-256 | 1c0d0c23e358d34d9e85926d021ded8002c0499b37da0341a8a79ce78f8290c1 |
Hashes for oracledb-2.2.0-cp311-cp311-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d0245f677e27ee0990eb0213485031dacdc837a89569563f1594b82ccb362255 |
|
MD5 | 3a77243e51034e7b454de7bec15eca9e |
|
BLAKE2b-256 | 1d0f26398ca807c06bcf728f6574bb4365100a70ee6fc1edc088cb42906f4054 |
Hashes for oracledb-2.2.0-cp311-cp311-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6c7da69d18cf02e469e15215af9c6f219256972a172c0e544a2ecc2a5cab9aa5 |
|
MD5 | da3b5e4fe38d097f3575af1fb737728c |
|
BLAKE2b-256 | 10565da45eaf7531115b553ed62dfeaaef033dba9931a2d01818b0e74517de6a |
Hashes for oracledb-2.2.0-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4e461d1c7ef4d3f03d84595a13754390a62300976782d7c29efc07fcc915e1b3 |
|
MD5 | 24576b0f1f1caf576d2d9b2d3f239eb8 |
|
BLAKE2b-256 | b2135392baa5b335ce34bd94abb88d5647c5207a63e28cad8388c2168c79014d |
Hashes for oracledb-2.2.0-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 61bbf9cd64a2f3b65a12550329b2f0caed7d9aa5e892c0ce69d9ea7b3cb3cb8e |
|
MD5 | ab26686b4935e1dc640cf730f6aa1114 |
|
BLAKE2b-256 | 24eb3d0d32e861ef2d875418d035827a4e505952b674d049f3a8ff5d89702d17 |
Hashes for oracledb-2.2.0-cp311-cp311-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c4b7e14b04dc2af4697ca561f9bcac110a67a7be2ccf868d789e92771017feca |
|
MD5 | 25712505b3e7bf7248605e4b7f729af7 |
|
BLAKE2b-256 | e6ddd6fccbeaadde5f02b8fb67ce72e365e6a79fe45089ad5a46be93e2708b00 |
Hashes for oracledb-2.2.0-cp310-cp310-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | efed536635b0fec5c1484eda55fad4affa57672b87596ec6273123a3133ba5b6 |
|
MD5 | 7b065cb90d79f4258e3d241ef67bb9d9 |
|
BLAKE2b-256 | 8690e8b2981d548cc10616dd66482adbf8650a2af011373c48a284d331a2943f |
Hashes for oracledb-2.2.0-cp310-cp310-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c2e2e3f00d7eb7f4dabfa8996dc70db03bd7dbe474d2d1dc381daeff54cfdeff |
|
MD5 | 8ea2547ef562bf3128cf06404843e4de |
|
BLAKE2b-256 | f6f2b491b824c6d9ef7cd0388b7a1c6c0172e7f2ef2207d7cf91266bc8896892 |
Hashes for oracledb-2.2.0-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 19408844bd4af5b4d40f06c3e5b88c6bfce4a749f61ab766f41b22c4070c5c15 |
|
MD5 | 5dfa7c62ad94dc899436bb22bf794f8d |
|
BLAKE2b-256 | 091581bf7c6f802e66dd2e47013168a4dd6c5ca938e94f6422cfaca51dc93625 |
Hashes for oracledb-2.2.0-cp310-cp310-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | fa5c2982076366f59dade28b554b43a257ad426e55359124bc37f191f51c2d46 |
|
MD5 | 8b84f4641496fd4bc3d46586838e176b |
|
BLAKE2b-256 | 82b8a3e66b1eefeef2baff1eac1c7611380b84d0b89af8aab51b98e17ab18efa |
Hashes for oracledb-2.2.0-cp310-cp310-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 253a85eef53d97815b4d838e5275d0a99e33ec340eb4b945cd2371e2bcede46b |
|
MD5 | edc497fc5c06043962fc6b3b08c29509 |
|
BLAKE2b-256 | 2f497c807201d48f796a1f1b126a9395a7dc416b1b0b3f008063b92b9cee2e0f |
Hashes for oracledb-2.2.0-cp39-cp39-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0b4968f39871d501ab16a2fe05b5b4ae954e338e6b9dcefeb9bced998ddd4c4b |
|
MD5 | 67c4d48a70772f518b5d3e31168435de |
|
BLAKE2b-256 | c489c1f8625f10690f6c07b53941e3f7eb7374d4cbe9c92ad8249ff610a48651 |
Hashes for oracledb-2.2.0-cp39-cp39-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 35b6524b57979dbe8463af06648ad9972bce06e014a292ad96fec34c62665a8b |
|
MD5 | 36110aff22b657c97dd9dedb4d8f9aad |
|
BLAKE2b-256 | 62cc112a52d0f1ee3c2c2a3b03b29a4449d297feae2e385d9885fd12106a804c |
Hashes for oracledb-2.2.0-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ba96a450275bceb5e0928e0dc01b5fb200e81ba04e99499d4930ccba681fd88a |
|
MD5 | fa1b296427ddc59b7d86f568e494a1ce |
|
BLAKE2b-256 | bca9fa78d717d09702b524e47b8a3a978f852b4bf717191596634565754cdac2 |
Hashes for oracledb-2.2.0-cp39-cp39-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | de3f9fa10b5f5c5dbe80dc7bdea5e5746abd411217e812fae66cc61c68f3f8f6 |
|
MD5 | b5bbc9bcd79a518fbd30c34ac90b068f |
|
BLAKE2b-256 | ffee9c31b1d66f8ec0ed98f770dd2731fc097e74fd5ab0061ed06cbcaaf1b23b |
Hashes for oracledb-2.2.0-cp39-cp39-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b924ee3e7d41edb367e5bb4cbb30990ad447fedda9ef0fe29b691d36a8d338c2 |
|
MD5 | 9b905b3c21e90691920d281e85eb5313 |
|
BLAKE2b-256 | a2152dbfab3c00173ee2b1508594b740df0e45617338e410ef4b999ecb7476bc |
Hashes for oracledb-2.2.0-cp38-cp38-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | c22a2052997a01e59a4c9c33c9c0593eebcb1d893addeda9cd57003c2e088a85 |
|
MD5 | ca147a4b2e20226ec6001ee86a829be7 |
|
BLAKE2b-256 | e4c3989800a1631b7631a8a24028ce7a6ec642b003d3bfe1ba6d57b14277ae8d |
Hashes for oracledb-2.2.0-cp38-cp38-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 97fdc27a15f6441434a7ef563f522c8ceac19c2933f2da1082125670a2e2fc6b |
|
MD5 | a44d3aa35295273aad0b39f5d0618c83 |
|
BLAKE2b-256 | eafdf025e353a72da7b127e162a8d644275ca1552a8817f270852ece7337274d |
Hashes for oracledb-2.2.0-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 581b7067283910a53b1ac1a50c0046058a21bd5c073d529bf695113db6d25f62 |
|
MD5 | a7d22a469f04ef9a562476442308b8e9 |
|
BLAKE2b-256 | 5244308d7e27ab3d38c6751877e0aebdf3f42a0aa79f20673b194ef14c36a13e |
Hashes for oracledb-2.2.0-cp38-cp38-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 437d7c5a36f7e72ca36e1ac3f1a7c087bffa1cd0ba3a84471e54506c8572a5ad |
|
MD5 | 167749b03cadb41aa02c17e50ad1546b |
|
BLAKE2b-256 | c41504857de46570c469b77fc338f6793bdb19c11055e7029823ade7e54a71d2 |
Hashes for oracledb-2.2.0-cp38-cp38-macosx_11_0_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e0010aee0ed0a57964ce9f6cb0e2315a4ffce947121e0bb1c618e5091e64bab4 |
|
MD5 | 4a833689bd970874bb4f868dd1ad54d8 |
|
BLAKE2b-256 | abfb220f003821c28301b8d099705d1940670d083b786297637ee8583f831248 |
Hashes for oracledb-2.2.0-cp37-cp37m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 1272bf562bcd6ff5e23b1e1fe8c3363d7a66fe8f48b1e00c4fb081d5436e1df5 |
|
MD5 | 6960805a139bffcee3a43f7a2c458b53 |
|
BLAKE2b-256 | 781700633409f2a1eec728823a3d2a700933490f9127edd4d10366cf14670203 |
Hashes for oracledb-2.2.0-cp37-cp37m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | bcef115bd147d6f267e3b09cbc3fc04189bff69e94d05c1e266c698668061e8d |
|
MD5 | cec934ebd6ed379b4a6f734f1daafe82 |
|
BLAKE2b-256 | 8f0eb715a0d7d81fb08b8c07c7ee248e44958430eccc3ecf37287008acfa9ddc |
Hashes for oracledb-2.2.0-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | aa1fe78ed0cbf98593c1f3f620f751b725b189f8c845577e39a372f44b2bf384 |
|
MD5 | 6934078c5513e5831f86475e584642fd |
|
BLAKE2b-256 | 2495c5f3845e62e5b1d946a9a41934b2ee4f5376724f771d88e74ad16c194079 |
Hashes for oracledb-2.2.0-cp37-cp37m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 14a7f2572c358604186d857c80f384ad03226e372731770911856541a06bdd34 |
|
MD5 | 93470e9da9cd34e4b0fe057b7d7845ec |
|
BLAKE2b-256 | 6e514f12b0fd41c3be88c9768ae0b8a8694fb634de1f9e583e3fe3a62aea58c4 |
Hashes for oracledb-2.2.0-cp37-cp37m-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b5ad105aabc8ff32e3d3a343a92cf84976cf2454b6a6ff02065383fc3863e68d |
|
MD5 | bd8e61d77feca798f4600cce1e1bc20f |
|
BLAKE2b-256 | 36c02724bc754620a7c15337a15b784f9c371fa6600fe3cefa9b04d8d5ebe6a8 |