Welcome to cx_Oracle’s documentation!

Note

cx_Oracle has a major new release under a new name and homepage python-oracledb.

New projects should install python-oracledb instead of the obsolete cx_Oracle driver.

Python-oracledb uses the same Python Database API as cx_Oracle, supports the feature requirements of frameworks that rely on this API, and has many new features.

To upgrade to python-oracledb, see Upgrading from cx_Oracle 8.3 to python-oracledb.

See python-oracledb documentation.

Contents:

User Guide

• Introduction to cx_Oracle
• cx_Oracle 8 Installation
• cx_Oracle 8 Initialization
• Connecting to Oracle Database
• SQL Execution
• PL/SQL Execution
• Using Bind Variables
• Using CLOB and BLOB Data
• Working with the JSON Data Type
• Simple Oracle Document Access (SODA)
• Working with XMLTYPE
• Batch Statement Execution and Bulk Loading
• Exception Handling
• Oracle Advanced Queuing (AQ)
• Continuous Query Notification (CQN)
• Transaction Management
• Tuning cx_Oracle
• Character Sets and Globalization
• Starting and Stopping Oracle Database
• High Availability with cx_Oracle
• Tracing SQL and PL/SQL Statements

API Manual

• Module Interface
• Connection Object
• Cursor Object
• Variable Objects
• SessionPool Object
• Subscription Object
• LOB Objects
• Object Type Objects
• Advanced Queuing (AQ)
• SODA
• Deprecations

Indices and tables

• Index

• Module Index

• Search Page