cx_Oracle | Obsolete mirror of https : //github

I'm looking for query to upsert(update/insert) into Oracle table from pandas dataframe. After searching I got this merge statement which updates the values when the key is present else it will insert.

This may be tricky but I'll try to put it clear. i have created two buttons, 1st button search folder and select individual filename as input, 2nd button select folder and take its directory as input and read all its files inside.

I want to create 3rd button(Execute) where it should know which button i selected and based on that it needs to do execute function.

Now,

I am trying to connect Oracle datasource using Python in my remote machine. My python version and cx_Oracle details as follows,

here is my code to connect Oracle,

I am trying to connect oracle database from AWS glue using cx_oracle but i am getting this error message

DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: "libclntsh.so: cannot open shared object file: No such file or directory". See https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html for help

I tried to downoad the so files as per the document and stored it in S3 which has been linked to Glue with --extra-files parameter but still getting same error message

I have tried this stackoverflow question and also tried to set rpath with s3 url but no success. Any idea would really help

I have to fetch data from an oracle database.

pandas.read_sql proved too slow so I moved to using the cx_oracle cursor.

The following piece of code correctly retrieves the data and the column names, unfortunately the inferred data type is wrong (for numbers).

We just got new computers at work and my SQL-code that I run in Python through cx_Oracle stopped working.

When I run the code it returns the ORA-01861 error saying that the literal does not match format string. I have read that this usually concerns dates, but in this case the error message refers to a char variable named period.

Basically my query says

I am trying to insert data into an oracle table, while in the process I am getting this error:

My company does not (yet) allow us to install or upgrade python3 neither install modules from pip on their servers. Even if I could, the machine is not connected to internet. But we can execute the python2 binary

Use the cx_Oracle module without using pip and internet

I got the idea to install cx_Oracle package on my computer and then copy the module files installed from my computer to the server.

So server dev folder looks like this (only listing interesting directories and files, omitting __pychache__, *.pyc and other useless *.py files):

I am getting the following error.

cx_Oracle.DatabaseError: DPI-1047: 64-bit Oracle Client library cannot be loaded: "dlopen(libclntsh.dylib, 1): image not found".

One fix that I found was to insert cx_Oracle.init_oracle_client(lib_dir=path) which lead to a Oracle Client Library has already been initialized Error.

However I do not call init_oracle_client anywhere in the code. I am using Python 3.8.11 and cx_Oracle 8.2.1 on a Mac.

When I initially ran the code, I did not have any Oracle Client installed. I then downloaded instantclient_19_8, but using that with init_oracle_client lead to the already initialized error. I saw this here https://cx-oracle.readthedocs.io/en/latest/user_guide/initialization.html.

I am not sure where the cx_Oracle binary is, when I go to the location that has my current anaconda environment, I see a cx_Oracle-doc folder that has readme files. In addition, an oradiag_my_username folder has been created in ~. Not sure what needs to be fixed.