Skip to main content

New level of functionality and performance in data access via Python

Project description

Python Connector for Oracle

Python Connector for Oracle is a connectivity solution for accessing Oracle databases from Python applications. It fully implements the Python DB API 2.0 specification. The connector is distributed as a wheel package for Windows, macOS, and Linux.

Direct connection

The connector enables you to establish a direct connection to Oracle from a Python application via TCP/IP, eliminating the need for the database client libraries. A direct connection increases the speed of data transmission between the application and Oracle database server and streamlines the deployment process since you don't have to distribute any client libraries with the application.

Secure communication

The connector supports encrypted communications using SSL/TLS, SSH tunneling, and HTTP/HTTPS tunneling.

Using the connector

To retrieve data from a database:

Import the module.

import devart.oracle

Connect to a database using the connect() module method and obtain a connection object.

my_connection = devart.oracle.connect(
    Direct=True,
    Host="your_server",
    ServiceName="your_service_name",
    UserName="your_username",
    Password="your_password"
)

Create a cursor object using the cursor() connection method.

my_cursor = my_connection.cursor()

Execute the SQL statement using the execute() cursor method.

my_cursor.execute("SELECT * FROM employees")

Retrieve the result set using one of the fetch*() cursor methods.

for row in my_cursor.fetchall(): 
    print(row)

Ordering and activating the license

You can purchase a license for the connector on the ordering page:
https://www.devart.com/python/oracle/ordering.html

To activate the license, follow the instructions in the documentation:
https://docs.devart.com/python/oracle/activate-a-license.htm

What's new

Python Connector for Oracle 1.2

  • Added support for Python 3.13

Project details


Download files

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

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distributions

devart_oracle_connector-1.2.0-cp313-cp313-win_amd64.whl (1.2 MB view details)

Uploaded CPython 3.13 Windows x86-64

devart_oracle_connector-1.2.0-cp313-cp313-win32.whl (1.0 MB view details)

Uploaded CPython 3.13 Windows x86

devart_oracle_connector-1.2.0-cp313-cp313-manylinux_2_34_x86_64.whl (2.4 MB view details)

Uploaded CPython 3.13 manylinux: glibc 2.34+ x86-64

devart_oracle_connector-1.2.0-cp313-cp313-macosx_10_13_universal2.whl (4.6 MB view details)

Uploaded CPython 3.13 macOS 10.13+ universal2 (ARM64, x86-64)

devart_oracle_connector-1.2.0-cp312-cp312-win_amd64.whl (1.2 MB view details)

Uploaded CPython 3.12 Windows x86-64

devart_oracle_connector-1.2.0-cp312-cp312-win32.whl (1.0 MB view details)

Uploaded CPython 3.12 Windows x86

devart_oracle_connector-1.2.0-cp312-cp312-manylinux_2_34_x86_64.whl (2.4 MB view details)

Uploaded CPython 3.12 manylinux: glibc 2.34+ x86-64

devart_oracle_connector-1.2.0-cp312-cp312-macosx_10_9_universal2.whl (4.6 MB view details)

Uploaded CPython 3.12 macOS 10.9+ universal2 (ARM64, x86-64)

devart_oracle_connector-1.2.0-cp311-cp311-win_amd64.whl (1.2 MB view details)

Uploaded CPython 3.11 Windows x86-64

devart_oracle_connector-1.2.0-cp311-cp311-win32.whl (1.0 MB view details)

Uploaded CPython 3.11 Windows x86

devart_oracle_connector-1.2.0-cp311-cp311-manylinux_2_34_x86_64.whl (2.4 MB view details)

Uploaded CPython 3.11 manylinux: glibc 2.34+ x86-64

devart_oracle_connector-1.2.0-cp311-cp311-macosx_10_9_universal2.whl (4.6 MB view details)

Uploaded CPython 3.11 macOS 10.9+ universal2 (ARM64, x86-64)

devart_oracle_connector-1.2.0-cp310-cp310-win_amd64.whl (1.2 MB view details)

Uploaded CPython 3.10 Windows x86-64

devart_oracle_connector-1.2.0-cp310-cp310-win32.whl (1.0 MB view details)

Uploaded CPython 3.10 Windows x86

devart_oracle_connector-1.2.0-cp310-cp310-manylinux_2_34_x86_64.whl (2.4 MB view details)

Uploaded CPython 3.10 manylinux: glibc 2.34+ x86-64

devart_oracle_connector-1.2.0-cp310-cp310-macosx_10_9_universal2.whl (4.6 MB view details)

Uploaded CPython 3.10 macOS 10.9+ universal2 (ARM64, x86-64)

devart_oracle_connector-1.2.0-cp39-cp39-win_amd64.whl (1.2 MB view details)

Uploaded CPython 3.9 Windows x86-64

devart_oracle_connector-1.2.0-cp39-cp39-win32.whl (1.0 MB view details)

Uploaded CPython 3.9 Windows x86

devart_oracle_connector-1.2.0-cp39-cp39-manylinux_2_34_x86_64.whl (2.4 MB view details)

Uploaded CPython 3.9 manylinux: glibc 2.34+ x86-64

devart_oracle_connector-1.2.0-cp39-cp39-macosx_10_9_universal2.whl (4.6 MB view details)

Uploaded CPython 3.9 macOS 10.9+ universal2 (ARM64, x86-64)

devart_oracle_connector-1.2.0-cp38-cp38-win_amd64.whl (1.2 MB view details)

Uploaded CPython 3.8 Windows x86-64

devart_oracle_connector-1.2.0-cp38-cp38-win32.whl (1.0 MB view details)

Uploaded CPython 3.8 Windows x86

devart_oracle_connector-1.2.0-cp38-cp38-manylinux_2_34_x86_64.whl (2.4 MB view details)

Uploaded CPython 3.8 manylinux: glibc 2.34+ x86-64

devart_oracle_connector-1.2.0-cp38-cp38-macosx_10_9_universal2.whl (4.6 MB view details)

Uploaded CPython 3.8 macOS 10.9+ universal2 (ARM64, x86-64)

devart_oracle_connector-1.2.0-cp37-cp37m-win_amd64.whl (1.2 MB view details)

Uploaded CPython 3.7m Windows x86-64

devart_oracle_connector-1.2.0-cp37-cp37m-win32.whl (1.0 MB view details)

Uploaded CPython 3.7m Windows x86

devart_oracle_connector-1.2.0-cp37-cp37m-manylinux_2_34_x86_64.whl (2.4 MB view details)

Uploaded CPython 3.7m manylinux: glibc 2.34+ x86-64

devart_oracle_connector-1.2.0-cp37-cp37m-macosx_10_9_x86_64.whl (2.5 MB view details)

Uploaded CPython 3.7m macOS 10.9+ x86-64

File details

Details for the file devart_oracle_connector-1.2.0-cp313-cp313-win_amd64.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp313-cp313-win_amd64.whl
Algorithm Hash digest
SHA256 51cf1a7e447205d0e479359d0a09de70cdee58616f502e02815301f45dbe7d0d
MD5 bf0e08ae092923f7c233d0d028a5044b
BLAKE2b-256 fdd6578075c536f19512fe68b3b7219eab176ba2b54c31151cc615ea2f5c45fa

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp313-cp313-win32.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp313-cp313-win32.whl
Algorithm Hash digest
SHA256 9b0b6ee6200b71c5b80b11a84e8396aba68d6ecbc893334ece45ea0734994f80
MD5 32589204b27a674f940c77613607dc16
BLAKE2b-256 4e2cd9c5d5c2099a398c873ded24872057891417c0bbbff825c610b93cb33d88

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp313-cp313-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp313-cp313-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 d665cd294a7d9c5af7267ba8e1ae9e896eb89b513fe0cbfb8e169d1b38580cf7
MD5 ff9f639c83a6fe3d62685f9634675b9f
BLAKE2b-256 cc34a9ebd78457f693ab78b5f4661a3d83cd6c525e68889149dfd24ba99db912

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp313-cp313-macosx_10_13_universal2.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp313-cp313-macosx_10_13_universal2.whl
Algorithm Hash digest
SHA256 bb4a538338fedfe7ece5d41352b08ad3c099768b310ef1caeafa562a4a411b77
MD5 d199913cfb388484587960efeaf7f354
BLAKE2b-256 35064bf16a0ce07e23caaeb9ebd6ffd3bb41099cebd4db2c5caa7a0e8050673d

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp312-cp312-win_amd64.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp312-cp312-win_amd64.whl
Algorithm Hash digest
SHA256 1f0ce42b96b2715be6101b87c3cec8c3af93e8c1db9339e77044f17d16162f3c
MD5 1165e036a2893e41dbfddbc1391f9c45
BLAKE2b-256 7a89717252f253619e2eae015bf8c836eaf7428221676a71c0002f9d90a71afc

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp312-cp312-win32.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp312-cp312-win32.whl
Algorithm Hash digest
SHA256 44971496014701bd05cf38062697ad276cb1626dea27376f5078594bcc2f0756
MD5 78c9c6ec61a0ff4e0a7628a5af3d8626
BLAKE2b-256 a21eadf00acfb8ec8681ff22a5e8f5046cb198c8d37123906363e84a22f35c78

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp312-cp312-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp312-cp312-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 d60334b21839f87891b3b04c5e119aee08416e993b4d9abb993d3f44aadd1de5
MD5 d7c883778d39be96c55a174b79290d24
BLAKE2b-256 4a0292267eb91bd560de910e8b385867c3d6bb5e8050e4a629a489f454dd4f7c

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp312-cp312-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp312-cp312-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 8c0c231976b7580f78395d8e0d1df7eee175aa07aaeb0dbc11e5d047b81f3e86
MD5 bcb507767ca25fda992376966101898a
BLAKE2b-256 5c17b0d1258bf6d38a1fa0e8e2d1f178e581df3c3c4809b66a6c6a5b98b57fce

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp311-cp311-win_amd64.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp311-cp311-win_amd64.whl
Algorithm Hash digest
SHA256 64ba01dd620ff6d394d76ee983c973d8ab12067f72e41eac0c845355f531f31c
MD5 29c6999e38b380a9ff34bf111cb46451
BLAKE2b-256 ee3510f8f00cc3b3a4b54c63a76b65f49715c8043adad2b229eb1282c4d6e072

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp311-cp311-win32.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp311-cp311-win32.whl
Algorithm Hash digest
SHA256 2da4b2d17d163ef1f2c5f732151b97aad6496b290e2956012d42817199a198b4
MD5 9f394629b150e95e1466b476611572c2
BLAKE2b-256 7f778136504abe938fae7f18ddca5b87f3fca905c4ff29eb2ce401bba3c2eb64

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp311-cp311-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp311-cp311-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 ddef636f9becde810f85a34df8135167e7ffb57860f1ad9eed8d772d114ef3c6
MD5 abdab2ea379edb0a9ab16731da8a94ad
BLAKE2b-256 5a7cf4e515e4a1b7a7094c26dbef70b4a28499a6deef5fa8ec480fb2cd9a072e

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp311-cp311-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp311-cp311-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 fb3ef80867e0bef2a9e359ed464bef57184f93925c180c2e9247fbcca36c022e
MD5 2a9529f49770f89bc9f2365070d8caf7
BLAKE2b-256 a4d1c4a8b9f798bae99dd1bdcb27c6a6fb01f797f6648f092cea8e25794a5e51

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp310-cp310-win_amd64.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp310-cp310-win_amd64.whl
Algorithm Hash digest
SHA256 9a2fa13aaa4b6f221e53e4fff49f758369930b3f9d90bc885119172299153bbd
MD5 ae9d335631aad82f66fbb99fdba51588
BLAKE2b-256 797b9d49c23eae3859c50436c0243aa098be866c08937691ccdf8bd001e0bed4

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp310-cp310-win32.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp310-cp310-win32.whl
Algorithm Hash digest
SHA256 407da87af9741d7facdf88bbe4b337d2840778f0f9a586b479e843f053a15ade
MD5 650f19800facdb0330e8164d5170a7a4
BLAKE2b-256 7a813af1da15e4fcc08c93a7e54f65d461a6384e394e69167c4a825b3fcf914f

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp310-cp310-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp310-cp310-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 150f1578f1adc47a8e126a1dd6a6f3a10a9f465bfd2e7aa7c4a015ed64019687
MD5 39f7f1170198f8ff6ea309b27a1da980
BLAKE2b-256 1129628a37bb585e1a4bec2694644d536b5d7013a22c42b94cacd45b7270f2be

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp310-cp310-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp310-cp310-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 cae6b66be2d5fcbdd3bbbd7e6e8266270cae820e3145cbae8088573671065edb
MD5 f83dc9b6de37b406381086d6bf1db4bf
BLAKE2b-256 18e2b563bfcd92fc771dfc5528d3c6a4e91769002bd5752c5bc1525887048bd0

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp39-cp39-win_amd64.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp39-cp39-win_amd64.whl
Algorithm Hash digest
SHA256 3c26959ea70c23d23d1aab8b81cb4e1a9872d2c1ddaaf50c7d988961899a5d5b
MD5 a7efeaf58d2cd2a5c9524e6bd7fcd1ee
BLAKE2b-256 1b3a7d3b545bf14edd0d4ab539432a937d70bcdbd7f4f5ea68d85ebf221d457e

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp39-cp39-win32.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp39-cp39-win32.whl
Algorithm Hash digest
SHA256 b202bf9dee00eb2da2ec52be6ada1d61fdbfec42f89ebc71938b42c869ef3256
MD5 753f250faed4cb7c9a42a2bd860bd233
BLAKE2b-256 0da1d7de912446fc759a398a2f6a3a40bbea2e32b0c9225dde8a847e12f64a9a

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp39-cp39-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp39-cp39-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 239168a43a03d039f418bad172df9fcc1f439767dca0c7a768aea757d963a550
MD5 e1be155d678361de52d19c10beea86f5
BLAKE2b-256 96c398118df0b13e18bfe55b5e7f4be4bb22f1a44afeb91a468b0abd30b73b90

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp39-cp39-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp39-cp39-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 6b0d4119089227435c1ef87e3676e55036bb09faaeed4f9ef294f0c9f3604ef2
MD5 7b18fd35d5722a0013773f0e2a4e8afc
BLAKE2b-256 3bc3c720b4a42e796598fbc85b7681a26fee5b2eeabacc66c7152c18065bd06c

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp38-cp38-win_amd64.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp38-cp38-win_amd64.whl
Algorithm Hash digest
SHA256 9ee355a8e36fa237f266e724c102fbe2e32699cb993447eff609bbb260d9d17d
MD5 423d019035f6a419a47af45ade963b04
BLAKE2b-256 0f137881fb63d94b283e39bc274fed3cd51eade095be4f8a0d9a6e0374cf4cbb

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp38-cp38-win32.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp38-cp38-win32.whl
Algorithm Hash digest
SHA256 581958d935a88dff00e921d7e5a7127a433284bb58dd73a63f8c64f34a9a5add
MD5 62a7648414a200515674bb3bd3cdceb7
BLAKE2b-256 db05f6ad0f0accddcde39df9361ae37b286c315864e73383fa28e58352479bfa

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp38-cp38-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp38-cp38-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 5db898ae7b57dcd659c59ad61512d13041beb4a6fab84c1d0243abcefe3b565f
MD5 f2dc07d0976235de6dcba8702cb189f6
BLAKE2b-256 35711c16647a1ccf4f701dd11ad5d4b869fcd9ee5a69870fc237a2c3d4e3ce68

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp38-cp38-macosx_10_9_universal2.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp38-cp38-macosx_10_9_universal2.whl
Algorithm Hash digest
SHA256 68ef826c775027e428a377200fb2c69a78cb97d3f531edde2e61a39bfc19badf
MD5 266dc8453c1a616fa522c024a1d0e9d3
BLAKE2b-256 469599b88da0d7dbea7a6e2dfa2d26f093454aee34b38314e98e12e024f11222

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp37-cp37m-win_amd64.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp37-cp37m-win_amd64.whl
Algorithm Hash digest
SHA256 fe317e8b8626dde03bbfe0e68513038b465d09917d628d64f967c0f8239e3bce
MD5 2770990046987c00ff3a5d596f0925f7
BLAKE2b-256 f4e2c47772795f96946fa78e616bb6ad3f35555297978cd15d722eaaba4589cc

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp37-cp37m-win32.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp37-cp37m-win32.whl
Algorithm Hash digest
SHA256 c9c027c7b66559e0e39e743e0cbd3041ddc9f62c1672387630446114fad0e0aa
MD5 f230cc3d1ade954d7753b26485fb6271
BLAKE2b-256 5d5604d28890a9ed5a77e6398d52f54a3c392ca6df060da08df56f37b96ae084

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp37-cp37m-manylinux_2_34_x86_64.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp37-cp37m-manylinux_2_34_x86_64.whl
Algorithm Hash digest
SHA256 fe0d5c17952e17c7891c810ddb16d979131831121307ad66baa08cb3ceb3958c
MD5 6c14b97795cf5e03e7dba2c818eb1af7
BLAKE2b-256 37908093929e2f9bec9e6ea0dcf575cd8a875e3ee6e490a48bce45a8bad6eaee

See more details on using hashes here.

File details

Details for the file devart_oracle_connector-1.2.0-cp37-cp37m-macosx_10_9_x86_64.whl.

File metadata

File hashes

Hashes for devart_oracle_connector-1.2.0-cp37-cp37m-macosx_10_9_x86_64.whl
Algorithm Hash digest
SHA256 cfe2d9fa3e8299c4891440e0ac3a7fc6351ba154ed9663c5c23be26dbf7a3cce
MD5 8a30b5c65b746ab7103655deecc8d077
BLAKE2b-256 a0942ae4ca546b36933e33af3277d6e1236f7a152878d4572003ca8aea775025

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page