oracle/python-oracledb
Python driver for Oracle Database conforming to the Python DB API 2.0 specification with many advanced features. Fast, small, portable. Enterprise ready.
python-oracledb 4.0.1 is now released. This release addresses a number of issues. See the [full release notes](https://python-oracledb.readthedocs.io/en/latest/release_notes.html#oracledb-4-0-1-may-2026) for all of the details.
📋 Changes
- support for Oracle AI Database 26ai Deep Data Security in thin mode
- support for Continuous Query Notification (CQN) and Advanced Queuing (AQ) notifications in thin mode
- new functions to help developers prevent SQL injection when processing user input to create SQL statements
- improved cloud native authentication
- improved support for data frames (binary views "vb" and string views "vu" formats now accepted)
python-oracledb 3.4.2 is now released. This release addresses a number of issues. See the [full release notes](https://python-oracledb.readthedocs.io/en/latest/release_notes.html#oracledb-3-4-2-january-2026) for all of the details.
python-oracledb 3.4.1 is now released. This release addresses a number of issues. See the [full release notes](https://python-oracledb.readthedocs.io/en/latest/release_notes.html#oracledb-3-4-1-november-2025) for all of the details.
📋 Changes
- support for Direct Path Load in thin mode for fast data ingestion
- support for data frames is no longer considered a pre-release
- support for type mapping when querying with data frames
- support for ingesting more Apache Arrow data types
- support for ingesting Apache Arrow data frames containing multiple chunks
- support for cursor.executemany() operating on large input data in batches
- fine-grained control over LOB and number handling
- new optional install dependencies for plugins
📋 Changes
- support for sessionless transactions with Oracle Database 23ai
- support for ingestion of dataframes
- support for the ArrowArrayStream PyCapsule interface
- pre-built binaries for Python 3.14 (this version is in the release candidate phase currently)
📋 Changes
- support for recipient lists in Oracle Advanced Queuing with thin mode
- support for fetching VECTOR columns in data frames
- support for Instance Principal authentication when using OCI Cloud Native Authentication
- support for Oracle Database 23ai multi-pool DRCP
python-oracledb 3.1.1 is now released. This release addresses a number of reported issues. See the [full release notes](https://python-oracledb.readthedocs.io/en/latest/release_notes.html#oracledb-3-1-1-may-2025) for all of the details.
📋 Changes
- support added for scrollable cursors in thin mode
- improved support for AQ in thin mode
- improvements to data frame fetching
📋 Changes
- initial support for AQ in thin mode
- an Apache Arrow PyCapsule interface for efficient data exchange with external libraries
- support for Oracle Database 23.7 SPARSE VECTOR
- namespace package `oracledb.plugins` that can be used for extension of python-oracledb
- support for centralized configuration providers (Oracle Cloud Infrastructure Object Storage and Microsoft Azure App Configuration) as well as file-based configurations
- cloud native authentication support through the integration of Oracle Cloud Infrastructure (OCI) and Azure SDKs
python-oracledb 2.5.1 is now released. This release addresses a number of reported issues. See the [full release notes](https://python-oracledb.readthedocs.io/en/latest/release_notes.html#oracledb-2-5-1-december-2024) for all of the details.
python-oracledb 2.5.0 is now released. This release adds a number of new features and corrects a number of issues. See the [full release notes](https://python-oracledb.readthedocs.io/en/latest/release_notes.html#oracledb-2-5-0-november-2024) for all of the details.
python-oracledb 2.4.1 is now released. This release addresses one reported issue. See the [full release notes](https://python-oracledb.readthedocs.io/en/latest/release_notes.html#oracledb-2-4-1-august-2024) for all of the details.
python-oracledb 2.4.0 is now released. This release adds support for Oracle Database 23ai pipelining and corrects a number of reported bugs. See the [full release notes](https://python-oracledb.readthedocs.io/en/latest/release_notes.html#oracledb-2-4-0-august-2024) for all of the details.
python-oracledb 2.3.0 is now released. This release adds support for a new VECTOR storage format (BINARY) available in Oracle Database 23.5. It also implements a number of other requested features and corrects a number of reported bugs. See the [full release notes](https://python-oracledb.readthedocs.io/en/latest/release_notes.html#oracledb-2-3-0-july-2024) for all of the details.
python-oracledb 2.2.1 is now released. This release addresses a number of reported issues. See the [full release notes](https://python-oracledb.readthedocs.io/en/latest/release_notes.html#oracledb-2-2-1-may-2024) for all of the details.
python-oracledb 2.2.0 is now released. This release adds support for VECTOR columns (new to Oracle Database 23ai) and INTERVAL YEAR TO MONTH columns, implements a number of other requested features and corrects a number of reported bugs. See the [full release notes](https://python-oracledb.readthedocs.io/en/latest/release_notes.html#oracledb-2-2-0-may-2024) for all of the details.
python-oracledb 2.1.2 is now released. This release addresses a number of reported issues. See the [full release notes](https://python-oracledb.readthedocs.io/en/latest/release_notes.html#oracledb-2-1-2-april-2024) for all of the details.
python-oracledb 2.1.1 is now released. This release addresses a number of reported issues. See the [full release notes](https://python-oracledb.readthedocs.io/en/latest/release_notes.html#oracledb-2-1-1-march-2024) for all of the details.
python-oracledb 2.1.0 is now released. This release adds support for additional features new to Oracle Database 23c and corrects a number of reported bugs. See the [full release notes](https://python-oracledb.readthedocs.io/en/latest/release_notes.html#oracledb-2-1-0-march-2024) for all of the details.
python-oracledb 2.0.1 is now released. This release addresses a number of reported issues. See the [full release notes](https://python-oracledb.readthedocs.io/en/latest/release_notes.html#oracledb-2-0-1-january-2024) for all of the details.
python-oracledb 2.0.0 is now released. This release adds support for asynchronous programming with asyncio and a large number of smaller enhancements and bug fixes. See the [full release notes](https://python-oracledb.readthedocs.io/en/latest/release_notes.html#oracledb-2-0-0-december-2023) for all of the details.
python-oracledb 1.4.2 is now released. This release addresses one issue and begins to supply pre-built binaries for Python 3.12. See the [full release notes](https://python-oracledb.readthedocs.io/en/latest/release_notes.html#oracledb-1-4-2-october-2023) for all of the details.
python-oracledb 1.4.1 is now released. This release addresses a number of reported issues. See the [full release notes](https://python-oracledb.readthedocs.io/en/latest/release_notes.html#oracledb-1-4-1-september-2023) for all of the details.
python-oracledb 1.4.0 is now released. This release addresses a large number of smaller enhancements and bug fixes. See the [full release notes](https://python-oracledb.readthedocs.io/en/latest/release_notes.html#oracledb-1-4-0-august-2023) for all of the details.
python-oracledb 1.3.2 is now released. This release addresses a number of reported issues. See the [full release notes](https://python-oracledb.readthedocs.io/en/latest/release_notes.html#oracledb-1-3-2-june-2023) for all of the details.
python-oracledb 1.3.1 is now released. This release addresses a number of reported issues. See the [full release notes](https://python-oracledb.readthedocs.io/en/latest/release_notes.html#oracledb-1-3-1-april-2023) for all of the details.
python-oracledb 1.3.0 is now released. This release adds support for binding and fetching data of type oracledb.DB_TYPE_JSON in thin mode. It also addresses a large number of smaller enhancements and bug fixes. See the [full release notes](https://python-oracledb.readthedocs.io/en/latest/release_notes.html#oracledb-1-3-0-march-2023) for all of the details.
python-oracledb 1.2.2 is now released. This release addresses a number of reported issues. See the [full release notes](https://python-oracledb.readthedocs.io/en/latest/release_notes.html#oracledb-1-2-2-january-2023) for all of the details.
python-oracledb 1.2.1 is now released. This release addresses a number of reported issues. See the [full release notes](https://python-oracledb.readthedocs.io/en/latest/release_notes.html#oracledb-1-2-1-december-2022) for all of the details.