Oracle Python Developer Center
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.
Ready for Cloud
Deploy cx_Oracle in the cloud, or connect to a cloud database
cx_Oracle Interface for Python is cloud ready:
Whether Python is in the cloud or on-premise, you can install cx_Oracle and connect to cloud databases. Follow the normal cx_Oracle installation process for the operating system. Cloud specific articles are shown below.
- Using On-Premise Scripting Languages with Oracle Database Exadata Express Cloud Service
- Using On-Premise Scripting Languages with Oracle Database Cloud Service
- Using Application Container Cloud Service and Oracle Database Cloud Service
- Using Application Container Cloud Service and Oracle Database Exadata Express Cloud Service
- Create Python Applications in Oracle Application Container Cloud Service
cx_Oracle is available on PyPI
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
- Oracle Database 12c JSON datatype
- Large Objects: CLOBs and BLOBs
- Simple Oracle Document Access (SODA)
- 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
Resources
Contact Us
- US Sales: +1.800.633.0738
- Global Contacts
- Support Directory
- Subscribe to Emails