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.3.0-cp312-cp312-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b70f978d67d8f56c9fc6620f4b657a4f602889b5e867481e44ef2e1f19d83418 |
|
MD5 | f97a0527b9d4251ca0fa95efa4a46aed |
|
BLAKE2b-256 | eaff67bc3d0f02defc5886082bd42aa9adfcdc0df10e55f36c12bf9e766ffeef |
Hashes for oracledb-2.3.0-cp312-cp312-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 04ec87866b4a9e20259a7c20a0e14e03464de06669a1a33d6419aaa04f58ff4c |
|
MD5 | 1f82fac33ffc29754a1bd1efa2321ce8 |
|
BLAKE2b-256 | c1300808be05d8318feaf3126d89faaacbdf3042faf52149e077fa283a9f2af4 |
Hashes for oracledb-2.3.0-cp312-cp312-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | be7d812c74a64f9e8d77323aca59a7fd8e8057b6ef887a0fb6139a0193eeb3e5 |
|
MD5 | 34f477229dfa6d1660b88baabc154506 |
|
BLAKE2b-256 | fd3b00ff32bd06772b0feefcf6954ce79a09483491891bda8b9376ec5b3f33a6 |
Hashes for oracledb-2.3.0-cp312-cp312-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ce9720a0d73c1b01ac6f7524b088527152a9671334687a37940e234cb375698b |
|
MD5 | 84afb5613a283e01da79c517fc0709e9 |
|
BLAKE2b-256 | f42916526048e59901687f55b97b3b61a235af8e3b998ca4b6b358a9e1a65182 |
Hashes for oracledb-2.3.0-cp312-cp312-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b8692d2c505d6d2970b0502d28fab8aedc17661b6856b80cb02cf3d38dc2e453 |
|
MD5 | 9f7c37719d6a88c9eeb2c16ea301db24 |
|
BLAKE2b-256 | 54674fb69ba882ba7fd813062cd4d7b1ef5a5f4ae156cc2173388b33bed20416 |
Hashes for oracledb-2.3.0-cp311-cp311-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 84518d8c690924a20c2eec2f26db13ba5adb499a8c37863ce5db1b81fc74784d |
|
MD5 | 84a124e910c37199247b2614f92e546f |
|
BLAKE2b-256 | 055140325a410bbb1184a25a9d28fd4e01b1faaa17ce53230e0bd7fe8796fee4 |
Hashes for oracledb-2.3.0-cp311-cp311-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0ec01e08edef3f2e45523ad797e2c9b448415b4ab58a62194c49f9ecdcc457a7 |
|
MD5 | 454b2bfa948b2a656cfe1b1716d735bb |
|
BLAKE2b-256 | 0f140661735341178f6faaf758b39b71cf1f8bb98c8812f4e505944ed8eb31ea |
Hashes for oracledb-2.3.0-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0eb3d1ff61d319012a2761c137b391f432fa952de000cdec14da018bb42974d0 |
|
MD5 | 66c93652f1d41c29379dfc8997c2eb6c |
|
BLAKE2b-256 | e5221748b777be3584b8dcea7ddedcb5a5073d68c4867a7395473f2aa146e180 |
Hashes for oracledb-2.3.0-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 990e17f0cd12ae6bff186fdc306dccc0a55e08f6df8df8346b3abedf382766b2 |
|
MD5 | cb7296959f882c1d29062f9076bb5268 |
|
BLAKE2b-256 | dd4524f269c53e7412d22c97a75a53618f50312903ea540a2da6b6528dec217d |
Hashes for oracledb-2.3.0-cp311-cp311-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b0d99d94c7b5c731558a28a7f9c50bf7ff88e3cef0b82d43b0660a7e3af412d2 |
|
MD5 | be3a588c4109a164b8ef2e0714a3c03d |
|
BLAKE2b-256 | b99767039828f635e4c9bbb2c05f7cd53f41c3a0fc776c92f210fd1f47a175b5 |
Hashes for oracledb-2.3.0-cp310-cp310-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6572540ac4eb966161a7e5ae02ce40b6eb4b15a75da2578a8e3b32940ae198f4 |
|
MD5 | 1b9391e866f4da1bf1445427d2babd01 |
|
BLAKE2b-256 | f8ec639adcb21303719c799266b60e653dc7eb6f1eedbfed345ce477d0d2702d |
Hashes for oracledb-2.3.0-cp310-cp310-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 614985c65a0625e33db566ed72c2f5c2fb9b67cd15cd6fcac1f72b70794e91d3 |
|
MD5 | afbe9d7faad36a8b27a7927ce947806d |
|
BLAKE2b-256 | 0f5b5c3523dc3ab4d9668f48afa29f2f6f258b7ec97b2c95147d4e6b6cbadf19 |
Hashes for oracledb-2.3.0-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 22fe82e9c7508a5de8c0df176d76780560d3198a7cd5eba02619bcbf3d364549 |
|
MD5 | 3080a3086f19d492ec0fafe5f7799d9f |
|
BLAKE2b-256 | d39ad5b52619ecca57de17334fbc8bf9a17cfc0ec4a43890c3a79f821a02a00c |
Hashes for oracledb-2.3.0-cp310-cp310-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | db4318646eefd98a215d527a64bc6afd1290a624f1b5fc5fe18dd27388d79266 |
|
MD5 | b6789538032d5f83b059e9cd91b47411 |
|
BLAKE2b-256 | ff47c8ffb16392d302515289667ad330b3773a7a938c2b9c505532b7087830f0 |
Hashes for oracledb-2.3.0-cp310-cp310-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | b10ae80d93a9442b8e966b52d45d8add5b978eade870bbe9be3c735c577dc2da |
|
MD5 | 10851fe0c7d1966737270091e4e6b3f1 |
|
BLAKE2b-256 | c61bc895c9f079b68111d6ce90480b2cc6a3ac5ed580ce6956394d7eb3a41d6e |
Hashes for oracledb-2.3.0-cp39-cp39-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d2883ebdb0388d791c8360558161cd2384880028836905f3068022bccf855e48 |
|
MD5 | e7ef3ab3fa62c76fb736796e0c176ac2 |
|
BLAKE2b-256 | 48d310b6e6657e60150d7cbde95dfd3daafbd6b420617fc2c17e04be6e5cea40 |
Hashes for oracledb-2.3.0-cp39-cp39-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | bdff4779346d6eaea612638b583e0a70fce30f56c4031ac611c13548130c69c0 |
|
MD5 | 367a54a3987060e63169cc8cf927b90a |
|
BLAKE2b-256 | 70e89a803d5df9a4d7e563f78fac20c20f95270c8d7f8ed62601c644f367f0d6 |
Hashes for oracledb-2.3.0-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f6b2ec83fcf9f1e7fd29be2310a05b93d85c0b9e4ac7030ba743077b68424e41 |
|
MD5 | 454987d56e8a59f93691bdba1f42d4a6 |
|
BLAKE2b-256 | baeb9d18f4c1db50392014e2d878a7938cff02e3c165991d7d9605d19e06940a |
Hashes for oracledb-2.3.0-cp39-cp39-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 4cd26ea11d981d35076c7f5c9c35d7690efa724c261df3d10c9f1e0fb5c6012f |
|
MD5 | 72dbf05fe54ed71930dbe14e6b50ec92 |
|
BLAKE2b-256 | 68197ef37f3a6ad2bdfdf1e3d95186a68b5fae772504cb358eb6ec33607f9058 |
Hashes for oracledb-2.3.0-cp39-cp39-macosx_10_9_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 060e2abc06bd8af40ab4bc6f42837a04014400aeceb6cdbfe01b7da693bc2ed4 |
|
MD5 | 7285967de48ba8e4d3b99b78dc1b9943 |
|
BLAKE2b-256 | 167e9d582132f87ced20f6e7771978b3d88af6a2165070b9dd04da0b91e000d6 |
Hashes for oracledb-2.3.0-cp38-cp38-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e76fdd2fdb507a466fe51b6ff5b8805cb073c0ebc6a2e041d064d7092fbb1a3e |
|
MD5 | f9264b029171b5961a8c3b485b6ce98b |
|
BLAKE2b-256 | 21ecec7c9edd323edc645f9c7a6f11f310f815db4971548454b626dff7e22f44 |
Hashes for oracledb-2.3.0-cp38-cp38-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d14e39af4990d717da2eba7399fb1e88f9062ac4a9e56f95568f10c33d470633 |
|
MD5 | e4bf34a8102cadbcdf95af4c8c9d986c |
|
BLAKE2b-256 | 608ad278e8f4d958f92d46dace03eac2c054cfff1c0103b2d3bfaf9bf78fa4dc |
Hashes for oracledb-2.3.0-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | aa84d7f0d14b972a5bd8dc79d55a82a6fff8077f489b36cd691e75808ecc2750 |
|
MD5 | d99d4561b8f6f86de18f46ec9d775927 |
|
BLAKE2b-256 | 5067ede8ccd9fbcce8e44543f3b968e9714b7cd8039cb159b792a5c1767bc48c |
Hashes for oracledb-2.3.0-cp38-cp38-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7222a408dcf116127ee665f78d83853d3208dc4d85ca545f383a6822f51478f9 |
|
MD5 | 56769a5f194b4773d867bf66c315f84b |
|
BLAKE2b-256 | 8059f9fe3f6b85e3a7885f04a8e77a7feb36107fba915a3929149cc5b399a74b |
Hashes for oracledb-2.3.0-cp38-cp38-macosx_11_0_universal2.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 712b2a741d03ce5957c581163b3e2b46abc0c17078d2ebb068501e18238538af |
|
MD5 | 0598666f36934b9bdda8c13ffcf09c56 |
|
BLAKE2b-256 | 9a5b48960c771efe165973b6d8bc812f8b5ded3633c5176f253ab90e904e246f |
Hashes for oracledb-2.3.0-cp37-cp37m-win_amd64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 421914f9124bd266fa9ccb42bb5e2fecc4b926dadc5a31bf84705e3a72d9fc6f |
|
MD5 | 0e355348c6f75c4fc9c42de976ecefc6 |
|
BLAKE2b-256 | c70a43c1f75d9ea0dca0edc6c05b6f0d52f4fd3d0df3136fb12cd31051444813 |
Hashes for oracledb-2.3.0-cp37-cp37m-win32.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 42d2df5362737985dbc403d3d9c6164bd6028bc9631b476793fbbf37227abe36 |
|
MD5 | e9d0aeaee6c2f3baaecf48210af1d467 |
|
BLAKE2b-256 | f37667542867a138aa51db6ff570abfad3dc33e5cfdb07001b6af01bc9cfe76f |
Hashes for oracledb-2.3.0-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7e451774cf90f651699ef19dc34bab868dc812ac07437f1eb0d897ba24ab6d1c |
|
MD5 | 878c5d6fe99cbe29cbf9c5286d5cd205 |
|
BLAKE2b-256 | 9c2576a9cf9d4741c89a838e449a717f86a670437dd17afd244ee87fffb46d6f |
Hashes for oracledb-2.3.0-cp37-cp37m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e7df9ed74dd15fd42d41fe784a390d8e7c44af9addaa0719e3b0a65554e0e3d1 |
|
MD5 | adc3802eb47081392a241b42f870ed55 |
|
BLAKE2b-256 | f0024b6a21b218d9ab654cd232147d43da4e9da128c5a9815014d4789dab24ed |
Hashes for oracledb-2.3.0-cp37-cp37m-macosx_10_9_x86_64.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5c95e5dbd688a71f120feeb47bd92d788b4af752db1b0141c49ce2966ee44c7b |
|
MD5 | ee9aacfa13b0d9a91d34249e62ba834b |
|
BLAKE2b-256 | cfb5f1be8650ef16771cc887c714f31a206add6504643ed2a3326d3bce143576 |