Oracle Python Developer Center

cx_Oracle 6.4 is now available on PyPI

High performance Python applications with Oracle Database. The cx_Oracle Python extension module enables access to Oracle Database. It conforms to the Python database API 2.0 specification with a considerable number of additions and a couple of exclusions.

Ready for Cloud

Deploy cx_Oracle in the cloud, or connect to a cloud database

cx_Oracle Interface for Python is cloud ready:

cx_Oracle 6.1 is now available on PyPI with support for Sharded Databases

cx_Oracle Features

 

  • Open Source
  • Maintained by Oracle
  • Hosted on PyPI and GitHub
  • Binary 'wheel' packages
  • SQL and PL/SQL Execution
  • Scrollable cursors
  • Extensive data type support
  • Binding to SQL objects, PL/SQL index-by tables, and records
  • Fetching of large result sets
  • REF CURSORs

 

  • Large Objects: CLOBs and BLOBs
  • Transaction Management
  • Session Pooling
  • Database Resident Connection Pooling (DRCP)
  • Privileged Connections and Database startup/shutdown
  • External Authentication
  • Advanced Queuing
  • Continuous Query Notification
  • Client Result Caching
  • End-to-end authentication and tracing

 

  • Implicit Results
  • Transaction Guard
  • Edition Based Redefinition
  • Large Row Counts
  • Row Prefetching
  • Statement Caching
  • Application Context
  • Sharded Databases
  • Oracle Database High Availability Features
  • Oracle Net Features including Encryption