I am establishing a connection to oracle 11g which is in a remote server using cx_oracle 7 with python 3.6.7. my OS in Ubuntu 18.04 I have installed oracle instant client library with libclntsh.so...

After much research I cannot figure out why I receive this error in my code. I'm trying to export a Pandas Dataframe to my Oracle table. I have successfully done this hundreds of times on other da...

I'm trying to install cx_Oracle and I get this error, I have the latest setuptools and pip installed. Has anyone had a similar problem and how did they solve it? I have Visual Studio: please see im...

I'm creating a RESTful API which needs to access the database. I'm using Restish, Oracle, and SQLAlchemy. However, I'll try to frame my question as generically as possible, without taking Restish o...

Found an example using cx_Oracle, this example shows all the information of Cursor.description. import cx_Oracle from pprint import pprint connection = cx_Oracle.Connection("%s/%s@%s" % (dbuser,...

cx_Oracle contains __enter__ and __exit__ on Connection objects, but not on Cursor objects. Thus, I use this everywhere to wrap cursors : class CursorWrapper(object): def __init__(self, connection...

I'd like to use the IN clause with a prepared Oracle statement using cx_Oracle in Python. E.g. query - select name from employee where id in ('101', '102', '103') On python side, I have a list [1...

I'm trying to build cx_Oracle for a Python 2.7.2 and Oracle 11g installation but the built cx_Oracle.so cannot find libclntsh.so.11.1 so importing cx_Oracle in Python fails. /mypath/cx_Oracle-5.1....

I have a connection string that looks like this con_str = "myuser/[email protected]:1521/ora1" Where ora1 is the SID of my database. Using this information in SQL Developer works fine, mean...

Is there a way to execute a sql script file using cx_oracle in python. I need to execute my create table scripts in sql files.

The following cx_Oracle code works fine when the database is up: #!C:\Python27 import cx_Oracle try: conn = cx_Oracle.connect("scott/tiger@oracle") try: curs = conn.cursor() curs.execute("SE...

I'm a new oracle learner. I'm trying to write a pandas dataframe into an oracle table. After I have made research online, I found the code itself is very simple, but I don't know why my code doesn'...

How can I access Oracle from Python? I have downloaded a cx_Oracle msi installer, but Python can't import the library. I get the following error: import cx_Oracle Traceback (most recent call las...

My goal is to use Pyinstaller to bundle an exe file from a simple python script that uses Tkinter and cx_oracle to access a database. The python code is developed on a windows machine with Anaconda...

I am trying to set up cx_Oracle to work with Python. I am using Python 2.7.10, 64-bit cx_Oracle version 6.0.2 MacOS Sierra 10.12.6 I set the following environment variables: export ORACLE_HOM...

I have this code: dsn = cx_Oracle.makedsn(hostname, port, sid) orcl = cx_Oracle.connect(username + '/' + password + '@' + dsn) curs = orcl.cursor() sql = "select TEMPLATE from my_table where i...

By default, cx_Oracle returns each row as a tuple. >>> import cx_Oracle >>> conn=cx_Oracle.connect('scott/tiger') >>> curs=conn.cursor() >>> curs.execute("selec...

I am trying to do a sanity testing of newly installed Oracle client 12.2 in RHEL 7 linux from a Python program, but it fails with the above error, not sure what I am missing on there. Please help w...

I want to create a docker image with oracle client and cx_oracle of python. I am using multi stage docker to build the image but I am missing an env variable due to which cx_oracle is not able to f...

Is it possible to call Python within an Oracle procedure? I've read plenty of literature about the reverse case (calling Oracle SQL from Python), but not the other way around. What I would like to...

So I found Help installing cx_Oracle but am still stuck. I downloaded the latest instantclient from oracle, and set ORACLE_HOME to the location of the extracted files (both direct and with a bin fo...

I am trying to store a Python datetime object in an ORACLE column of type date. so far, I have used, rpt_time = time.strftime('%Y-%m-%d %H:%M:%S') or rpt_time = str(datetime.datetime.now()) but al...

Newbie here trying to use python to do some database analysis. I keep getting the error: "error: cannot locate an Oracle software installation" When installing CX_oracle (via easy_install). The pr...

How do you connect to a remote server via IP address in the manner that TOAD, SqlDeveloper, are able to connect to databases with just the ip address, username, SID and password? Whenever I try to...

I want to execute an Oracle PL/SQL statement via cx_oracle in Python. Code looks like this: db = cx_Oracle.connect(user, pass, dsn_tns) cursor = db.cursor() ... sel = """ DECLARE c NUMBER := 0...