python-cx_Oracle | Python interface to Oracle Database | Database library

by oracle C Version: 8.3.0 License: Non-SPDX

X-Ray Key Features Code Snippets Community Discussions(4)Vulnerabilities Install Support

kandi X-RAY | python-cx_Oracle Summary

python-cx_Oracle is a C library typically used in Database, Oracle applications. python-cx_Oracle has no bugs, it has no vulnerabilities and it has medium support. However python-cx_Oracle has a Non-SPDX License. You can download it from GitHub.

cx_Oracle is a Python extension module that 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. See the homepage for a feature list. cx_Oracle 8.3 has been tested with Python versions 3.6 through 3.9. You can use cx_Oracle with Oracle 11.2, 12c, 18c, 19c and 21c client libraries. Oracle's standard client-server version interoperability allows connection to both older and newer databases. For example Oracle 19c client libraries can connect to Oracle Database 11.2. Older versions of cx_Oracle may work with older versions of Python.

Support

Quality

Security

License

Reuse

Support

python-cx_Oracle has a medium active ecosystem.

It has 854 star(s) with 355 fork(s). There are 74 watchers for this library.

It had no major release in the last 12 months.

There are 31 open issues and 599 have been closed. On average issues are closed in 92 days. There are no pull requests.

It has a neutral sentiment in the developer community.

The latest version of python-cx_Oracle is 8.3.0

Quality

python-cx_Oracle has no bugs reported.

Security

python-cx_Oracle has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

License

python-cx_Oracle has a Non-SPDX License.

Non-SPDX licenses can be open source with a non SPDX compliant license, or non open source licenses, and you need to review them closely before use.

Reuse

python-cx_Oracle releases are available to install and integrate.

Installation instructions are available. Examples and code snippets are not available.

Top functions reviewed by kandi - BETA

kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of python-cx_Oracle

Get all kandi verified functions for this library.

python-cx_Oracle Key Features

No Key Features are available at this moment for python-cx_Oracle.

python-cx_Oracle Examples and Code Snippets

No Code Snippets are available at this moment for python-cx_Oracle.

Community Discussions

Trending Discussions on python-cx_Oracle

Inheriting Airflow OracleHook in order to set cx_Oracle outputtypehandler due to SELECT ValueError

cx_Oracle installation fails with FileNotFoundError: [WinError 3]

Sharing cx_Oracle cursor between threads or processes

Python - Oracle 11g connection

QUESTION

Inheriting Airflow OracleHook in order to set cx_Oracle outputtypehandler due to SELECT ValueError

Asked 2020-Jul-22 at 16:38

I am querying a full table that is very old. It contains some corrupted data that I do not have the privileges to change or create a view from. Whenever I SELECT the data using the Airflow OracleHook get_records I get the error message "ValueError: year -4712 is out of range". I would like to handle this by returning None for this particular record as shown in this cx_Oracle solution: Problem empty date cause ValueError: year -9999 is out of range. This requires setting the cx_Oracle outputtypehandler attribute. When I run the following code, neither the OutputHandler or DateTimeConverter functions are called and the code fails with the same ValueError as when I use the base OracleHook class. Any help would be greatly appreciated!

...

ANSWER

Answered 2020-Jul-22 at 15:56

You want to override the get_records method from the airflow.hooks.dbapi_hook.DbapiHook class; it doesn't call out to OracleHook.get_cursor so your assignments won't work:

Source https://stackoverflow.com/questions/63035092

QUESTION

cx_Oracle installation fails with FileNotFoundError: [WinError 3]

Asked 2019-Jun-15 at 02:24

My organisation does not allow me to use pip to install Python libraries, hence i downloaded the zip for cx_Oracle (python-cx_Oracle-master.zip) from GIT and then tried to install it using install command, as below :

...

ANSWER

Answered 2019-Jun-15 at 02:24

You are missing the ODPI-C source code. You need to follow the instructions found in the documentation here.

Source https://stackoverflow.com/questions/56593623

QUESTION

Sharing cx_Oracle cursor between threads or processes

Asked 2019-Mar-05 at 22:03

I have a database in Oracle. I need to export some data, process them and save the data into the file. In the table is oracle sdo_geom and I need convert the geometry into the WKT format. The geometry is really big, a big polygons with thousand of vertices. I am using SDO_UTIL.TO_WKTGEOMETRY() function but it takes too long. Selecting (converting the geometry) into the database is a bottleneck in this case.

I think about multihreading or multiprocessing in Python. The scenario should looks something like this:

Create connection to the database
Create cx_Oracle.cursor
Then start multiple threads or processes sharing the cursor
In every thread (or process) I will select the data from the database (the same table) by chunks
Then the all the data will be send to the thread or process responsible for processing the data and saving to the file

I am selecting the data using fetchmany() via chunks:

...

ANSWER

Answered 2019-Mar-05 at 22:03

You cannot perform more than one action on a cursor or connection in cx_Oracle simultaneously. So you can't do simultaneous fetches, for example. If you attempt to do so you will discover that the fetches block. As such, I would suggest that you simply perform the fetch in one thread and pass the data fetched off to another thread or threads for processing.

The other possibility is to create a pool which permits you to create multiple connections and use them in multiple threads (use the threaded=True parameter when you create the pool). You can then use each connection to query a different portion of the data.

Source https://stackoverflow.com/questions/54945434

QUESTION

Python - Oracle 11g connection

Asked 2017-May-08 at 11:53

I want to connect python and oracle 11g. Python Version- 3.6.1 / 64 bit, Windows 7 -64 bit.

I have installed cx_Oracle from https://oracle.github.io/python-cx_Oracle/ The Code is as below -

...

ANSWER

Answered 2017-May-08 at 11:53

1. Download msvcp71.dll and msvcr71.dll from the web.
2. Save them to your C:\Windows\System32 folder.
3. Save them to your C:\Windows\SysWOW64 folder as well (if you have a 64-bit operating system).

Source https://stackoverflow.com/questions/43801391

Community Discussions, Code Snippets contain sources that include Stack Exchange Network