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.

Installation

Run python -m pip install oracledb

See python-oracledb Installation.

Dependencies and Interoperability

Python versions 3.6 through 3.11.

Prebuilt packages are available on Windows for Python 3.7 or later, on macOS for Python 3.7 or later, and on Linux for Python 3.6 or later.

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

See CONTRIBUTING

License

See LICENSE, THIRD_PARTY_LICENSES, and NOTICE.

Project details

Release history Release notifications | RSS feed

This version

1.2.2

Jan 19, 2023

1.2.1

Dec 1, 2022

1.2.0

Nov 14, 2022

1.1.1

Sep 29, 2022

1.1.0

Sep 14, 2022

1.0.3

Aug 2, 2022

1.0.2

Jul 18, 2022

1.0.1

Jun 14, 2022

1.0.0

May 25, 2022

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

oracledb-1.2.2.tar.gz (468.3 kB view hashes)

Uploaded Jan 19, 2023 source

Built Distributions

oracledb-1.2.2-cp311-cp311-win_amd64.whl (1.0 MB view hashes)

Uploaded Jan 19, 2023 cp311

oracledb-1.2.2-cp311-cp311-win32.whl (864.8 kB view hashes)

Uploaded Jan 19, 2023 cp311

oracledb-1.2.2-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (8.0 MB view hashes)

Uploaded Jan 19, 2023 cp311

oracledb-1.2.2-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl (7.8 MB view hashes)

Uploaded Jan 19, 2023 cp311

oracledb-1.2.2-cp311-cp311-macosx_10_9_universal2.whl (2.5 MB view hashes)

Uploaded Jan 19, 2023 cp311

oracledb-1.2.2-cp310-cp310-win_amd64.whl (1.1 MB view hashes)

Uploaded Jan 19, 2023 cp310

oracledb-1.2.2-cp310-cp310-win32.whl (946.7 kB view hashes)

Uploaded Jan 19, 2023 cp310

oracledb-1.2.2-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (7.3 MB view hashes)

Uploaded Jan 19, 2023 cp310

oracledb-1.2.2-cp310-cp310-manylinux_2_17_aarch64.manylinux2014_aarch64.whl (7.2 MB view hashes)

Uploaded Jan 19, 2023 cp310

oracledb-1.2.2-cp310-cp310-macosx_10_9_universal2.whl (2.6 MB view hashes)

Uploaded Jan 19, 2023 cp310

oracledb-1.2.2-cp39-cp39-win_amd64.whl (1.1 MB view hashes)

Uploaded Jan 19, 2023 cp39

oracledb-1.2.2-cp39-cp39-win32.whl (958.0 kB view hashes)

Uploaded Jan 19, 2023 cp39

oracledb-1.2.2-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (7.4 MB view hashes)

Uploaded Jan 19, 2023 cp39

oracledb-1.2.2-cp39-cp39-manylinux_2_17_aarch64.manylinux2014_aarch64.whl (7.2 MB view hashes)

Uploaded Jan 19, 2023 cp39

oracledb-1.2.2-cp39-cp39-macosx_10_9_universal2.whl (2.6 MB view hashes)

Uploaded Jan 19, 2023 cp39

oracledb-1.2.2-cp38-cp38-win_amd64.whl (1.1 MB view hashes)

Uploaded Jan 19, 2023 cp38

oracledb-1.2.2-cp38-cp38-win32.whl (968.9 kB view hashes)

Uploaded Jan 19, 2023 cp38

oracledb-1.2.2-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (7.5 MB view hashes)

Uploaded Jan 19, 2023 cp38

oracledb-1.2.2-cp38-cp38-manylinux_2_17_aarch64.manylinux2014_aarch64.whl (7.4 MB view hashes)

Uploaded Jan 19, 2023 cp38

oracledb-1.2.2-cp38-cp38-macosx_11_0_universal2.whl (2.6 MB view hashes)

Uploaded Jan 19, 2023 cp38

oracledb-1.2.2-cp37-cp37m-win_amd64.whl (1.1 MB view hashes)

Uploaded Jan 19, 2023 cp37

oracledb-1.2.2-cp37-cp37m-win32.whl (925.8 kB view hashes)

Uploaded Jan 19, 2023 cp37

oracledb-1.2.2-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (6.5 MB view hashes)

Uploaded Jan 19, 2023 cp37

oracledb-1.2.2-cp37-cp37m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl (6.5 MB view hashes)

Uploaded Jan 19, 2023 cp37

oracledb-1.2.2-cp37-cp37m-macosx_10_9_x86_64.whl (1.4 MB view hashes)

Uploaded Jan 19, 2023 cp37

oracledb-1.2.2-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl (6.6 MB view hashes)

Uploaded Jan 19, 2023 cp36

oracledb-1.2.2-cp36-cp36m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl (6.5 MB view hashes)

Uploaded Jan 19, 2023 cp36

Hashes for oracledb-1.2.2.tar.gz

Hashes for oracledb-1.2.2.tar.gz
Algorithm	Hash digest
SHA256	`dd9f63084e44642b484a46b2fcfb4fc921f39facf494a1bab00628fa6409f4fc`
MD5	`ddbfbc12238b09d0fe1695ae35f0b73b`
BLAKE2b-256	`6b85a1eaa9e96ad25aee72d70eee2e9f4070b88fcaa343a3270b865d1d1fc865`

Hashes for oracledb-1.2.2-cp311-cp311-win_amd64.whl

Hashes for oracledb-1.2.2-cp311-cp311-win_amd64.whl
Algorithm	Hash digest
SHA256	`18fb8e53bb00314cae5f35172e5d1ebfb10622fe04110719d06024429d3a5de2`
MD5	`71a1fcc49e1c3976475b2aea775d76f6`
BLAKE2b-256	`b6655370be383af17c9a042fe02a5cbb8e84cdb75e21f66152a3b587cd99a8e9`

Hashes for oracledb-1.2.2-cp311-cp311-win32.whl

Hashes for oracledb-1.2.2-cp311-cp311-win32.whl
Algorithm	Hash digest
SHA256	`daa72f6df90e21be2f2f83a6de67d50eee58efa5b6eb4ae615e87bcb3ca927ce`
MD5	`cdcc04ddbd4db3dfc7620bc2bee0f07d`
BLAKE2b-256	`c8b3ac8266e190539dde65ecf4d00ee334218844cc67d94fc738c9aedfb660a7`

Hashes for oracledb-1.2.2-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl

Hashes for oracledb-1.2.2-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm	Hash digest
SHA256	`75a61f9fbe07b23fe04b51f4a4aaa5c735a5aadfb424390feeb577f10058b7e7`
MD5	`650bfe413938ba2f37a799bf161174af`
BLAKE2b-256	`9b4189c6de766fcdc60c0723835f3325d87ed8d985f384e1415f20ca9871d750`

Hashes for oracledb-1.2.2-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl

Hashes for oracledb-1.2.2-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm	Hash digest
SHA256	`9feabdca7aeb165b94c523f5088a239f63bd5f01b1ad2a2442d88588e2895c8e`
MD5	`68ef5dd44d3cb459860e5e7e1b627229`
BLAKE2b-256	`11200ee7c40ede1ab33074d10572a5e5d1aff57371f3a9ef1c8f503a5af83274`

Hashes for oracledb-1.2.2-cp311-cp311-macosx_10_9_universal2.whl

Hashes for oracledb-1.2.2-cp311-cp311-macosx_10_9_universal2.whl
Algorithm	Hash digest
SHA256	`dd95620f53a4e0ef8516145ca98b93b8a5bb5dacb2637d80d8f59c34725c5371`
MD5	`7e4ebb799715da2b4d81ff299ea25dca`
BLAKE2b-256	`764976ea6e489d534c232030cf2a0a8c2c80d726d7565d03025e8d8ccf64a342`

Hashes for oracledb-1.2.2-cp310-cp310-win_amd64.whl

Hashes for oracledb-1.2.2-cp310-cp310-win_amd64.whl
Algorithm	Hash digest
SHA256	`903bf0670d28e4d602626f8dac2d923ed1267e0a7132b5a0819363ada335c80c`
MD5	`e6d66083071efd48979c278c0b71689d`
BLAKE2b-256	`6344f42545cc35c6b0927dca73328c64912da9cdf947913c6d5b37479862a472`

Hashes for oracledb-1.2.2-cp310-cp310-win32.whl

Hashes for oracledb-1.2.2-cp310-cp310-win32.whl
Algorithm	Hash digest
SHA256	`3265a02faf970fe6599a664c251c0f8ab3b29fdb1cf37c4a957928613a085aea`
MD5	`e869372623fcf586e7d7b853123bf04e`
BLAKE2b-256	`a5ff180cd156d9d72ecd2b8e3bbf3023bf2a0472c99368402940af67bbf44ed1`

Hashes for oracledb-1.2.2-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl

Hashes for oracledb-1.2.2-cp310-cp310-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm	Hash digest
SHA256	`411401e78054f84e0b6c43ef26fc023ed59a38055e2c29a6fb35ea8f68f5d619`
MD5	`771eb022fb0bbc78ca86b75f4aa1de0e`
BLAKE2b-256	`8f2dbfe9ff1df1ef9b653805fc28eaaf0eb79636e5eb23c736456e289169a418`

Hashes for oracledb-1.2.2-cp310-cp310-manylinux_2_17_aarch64.manylinux2014_aarch64.whl

Hashes for oracledb-1.2.2-cp310-cp310-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm	Hash digest
SHA256	`0ed94a1f1df6bc0eb00491e5fb39191df3f62d0ec9d4c829efc4d20258c3bd8a`
MD5	`0a7bd02fe939ed44cc6206af0d1d6f06`
BLAKE2b-256	`686ca9ff93582438e831e8cb127ba8fa6a0f0906d201de45827ca3f7cf17394d`

Hashes for oracledb-1.2.2-cp310-cp310-macosx_10_9_universal2.whl

Hashes for oracledb-1.2.2-cp310-cp310-macosx_10_9_universal2.whl
Algorithm	Hash digest
SHA256	`c4bc8bd73753c6dc341c92431e2f8976347df1075aac2601673d47ab61998109`
MD5	`5225b6f49805111b3fa252069b649d67`
BLAKE2b-256	`932c4a6865ab6b44dce0d69abf76c5018a8f977e34b2cf64eb94b5b4ee70fa82`

Hashes for oracledb-1.2.2-cp39-cp39-win_amd64.whl

Hashes for oracledb-1.2.2-cp39-cp39-win_amd64.whl
Algorithm	Hash digest
SHA256	`7271ee8702504268e1e5b088a81bb5a12e094d0956b8663b9bbbc7cb052df67b`
MD5	`ca106336a3a0b61f4ff683ed92cb0cf9`
BLAKE2b-256	`471e1813769079e0886748f9299bb2c880c6a677e4562a33633a7e84fd54f370`

Hashes for oracledb-1.2.2-cp39-cp39-win32.whl

Hashes for oracledb-1.2.2-cp39-cp39-win32.whl
Algorithm	Hash digest
SHA256	`284a5f10ee1873b3a281bc94d0829206a5c940f3fdbbf4bc1e0a9764cf5b6e8b`
MD5	`efde1383b0c94ace6cad9546597beaa4`
BLAKE2b-256	`8650a937b4d72943e07a4af285ded3832c6febc293bd76ea4369b507930d71c1`

Hashes for oracledb-1.2.2-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl

Hashes for oracledb-1.2.2-cp39-cp39-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm	Hash digest
SHA256	`e7dff8381e12808a529453e43a4d756d34452cab557923a88a71978ea2c8106e`
MD5	`c1181e9ad57c038e676106f909786989`
BLAKE2b-256	`0264f78c28745d15b085745554fc3e74ab4be77c0205f19ce2bb3cca4e5a07db`

Hashes for oracledb-1.2.2-cp39-cp39-manylinux_2_17_aarch64.manylinux2014_aarch64.whl

Hashes for oracledb-1.2.2-cp39-cp39-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm	Hash digest
SHA256	`8dc8953014897214e9b87cfd17a1a26fe07953dee8cfb6adc189081869b9a77e`
MD5	`d899ee85ee1756e59b969c5eb7751404`
BLAKE2b-256	`76b5ff5455a18d3ec1b953b4db7c87fa4d47fd7c119786459029434951a1ac9d`

Hashes for oracledb-1.2.2-cp39-cp39-macosx_10_9_universal2.whl

Hashes for oracledb-1.2.2-cp39-cp39-macosx_10_9_universal2.whl
Algorithm	Hash digest
SHA256	`48759de970c9f4cdfed60517ff580578e127e1d7606ab6a10baa7999c17dd534`
MD5	`273a2a6ebb1d07e44724566f954aeb76`
BLAKE2b-256	`d81baf8e5ba9588f22eabbb0342d1b6d857d1ab0b9ba5bc14dbe2b77187e8067`

Hashes for oracledb-1.2.2-cp38-cp38-win_amd64.whl

Hashes for oracledb-1.2.2-cp38-cp38-win_amd64.whl
Algorithm	Hash digest
SHA256	`533b40e2c8b4c24caa7f6fb58431d455964d0d4a4ca26d324cade986fa746e8e`
MD5	`659f4a67220827127a3a2cd169684c5b`
BLAKE2b-256	`eb733c6b54b31040e632a5f32f50cd2be2a4254ce864b0e5bd4183f7b5e208e0`

Hashes for oracledb-1.2.2-cp38-cp38-win32.whl

Hashes for oracledb-1.2.2-cp38-cp38-win32.whl
Algorithm	Hash digest
SHA256	`57a8125414899a48b5b6c8a46fe0570a31ec57b6a94d8aa1d0e6587fe2b3292d`
MD5	`db6c5dcbeecc6bf10905966c6df244b5`
BLAKE2b-256	`d351dddd8e54670d85fd31c982995d8e42eeb8a859c6377416228003fcbfbcec`

Hashes for oracledb-1.2.2-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl

Hashes for oracledb-1.2.2-cp38-cp38-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm	Hash digest
SHA256	`8eaf0e2717a81fa721b729cee5a0d9570e07dbf737cbbfef63e04389becf1dd3`
MD5	`866194858126b615a13fdd8ff2b3bec5`
BLAKE2b-256	`aca7632133211461731e60ccec3e1fb8823f9f04520c6c772d676b28599f3997`

Hashes for oracledb-1.2.2-cp38-cp38-manylinux_2_17_aarch64.manylinux2014_aarch64.whl

Hashes for oracledb-1.2.2-cp38-cp38-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm	Hash digest
SHA256	`5eb0a5bfe75a4bc320a73740abaabf1a6e4b49d3631ce0a60d896141eb612415`
MD5	`843fdde891df3aad91441ade69cbaceb`
BLAKE2b-256	`ac7fa20cac648c671c42c0ad7c116c3ad0ef630d9bb067de925496bfe243f1f0`

Hashes for oracledb-1.2.2-cp38-cp38-macosx_11_0_universal2.whl

Hashes for oracledb-1.2.2-cp38-cp38-macosx_11_0_universal2.whl
Algorithm	Hash digest
SHA256	`29814e527760e29fdaef3e8a1f39d357c232446ca1200432902ec420edb0325d`
MD5	`4499f887234afe2ec31f9a82edaa9f50`
BLAKE2b-256	`0654a40fd269d81b6aa130153c60b9fd56859da8c65dbdee8b7423cb51455caa`

Hashes for oracledb-1.2.2-cp37-cp37m-win_amd64.whl

Hashes for oracledb-1.2.2-cp37-cp37m-win_amd64.whl
Algorithm	Hash digest
SHA256	`0fbdaddca628c6ffdf26cc9bdffc982fb11996875e744794c8b911d3564cd301`
MD5	`5c245b7015a90d8b91610605c630e245`
BLAKE2b-256	`0da84af5d28bb0ea0636e7d5f406a081a796b8bf1ef7d4b26cd777779b18a470`

Hashes for oracledb-1.2.2-cp37-cp37m-win32.whl

Hashes for oracledb-1.2.2-cp37-cp37m-win32.whl
Algorithm	Hash digest
SHA256	`b782eebecb817e43ead815cfc461e3e907671170fe0e05d705e730dbfcd046c7`
MD5	`47c08c2656053770bc8cb435e145d4b6`
BLAKE2b-256	`c9d4d1dd3db52562ce7d1dd2b0dc0d802372b4226b97ae743299d9ce3d78d743`

Hashes for oracledb-1.2.2-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl

Hashes for oracledb-1.2.2-cp37-cp37m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm	Hash digest
SHA256	`fd7b5a66e5f17811ca6dc1ac40587ed89e478d7a5f15837603f4e5de8487ca2b`
MD5	`e7422d0d9c1b51392cb2c5ed3faf52cd`
BLAKE2b-256	`d2d5add05cbc03956b976bfd78b4338cbf4490c63cd321a743d14c4fe48338ac`

Hashes for oracledb-1.2.2-cp37-cp37m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl

Hashes for oracledb-1.2.2-cp37-cp37m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm	Hash digest
SHA256	`c6f921a427036618d8d19afbc5f706362149e47eedb70d3e64235a69c3a70896`
MD5	`abfd61003daa68c03dda3fa0f52a711e`
BLAKE2b-256	`f27b7508a9729be2a3bb254daca0a0a32c0284f4ebc47481fb53b380c7cbd541`

Hashes for oracledb-1.2.2-cp37-cp37m-macosx_10_9_x86_64.whl

Hashes for oracledb-1.2.2-cp37-cp37m-macosx_10_9_x86_64.whl
Algorithm	Hash digest
SHA256	`e4d490a9cc085009caba49f704f8397f92bf7897c3291e0e70edb4e0dfed8616`
MD5	`3d6296f1759a5527d6829085d39221b1`
BLAKE2b-256	`58b70c120a89b446189ef1b635951a9f6a7a3411f950eb799c3ff99a3344fdf3`

Hashes for oracledb-1.2.2-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl

Hashes for oracledb-1.2.2-cp36-cp36m-manylinux_2_17_x86_64.manylinux2014_x86_64.whl
Algorithm	Hash digest
SHA256	`25c24da912396cd7d945f208be9badba558a7a285a8c2ac99a574619dfe383e2`
MD5	`d163a39b158127b3c4b8b8267561ed06`
BLAKE2b-256	`408a5983433c5625ede4b0e0ca68f4e669a136ac3b108988d18fce4d1c760898`

Hashes for oracledb-1.2.2-cp36-cp36m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl

Hashes for oracledb-1.2.2-cp36-cp36m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl
Algorithm	Hash digest
SHA256	`d2ccdfef6669bf3452aa42b2be453df57d639fc026baf2b65e2a3c89b2df7aff`
MD5	`4fed44411104236fcb7cca71851b56ab`
BLAKE2b-256	`73f527c53a74658b6de7d919e9bcf6a2018ee3d040452151bdf236aedb8d14c4`