I have a query like this: SELECT prodId, prod_name , prod_type FROM mytable WHERE prod_type in (:list_prod_names) I want to get the information of a product, depending on the possible types are:...

I'm using Oracle Database with UTF-16 encoding. The diacritics is correctly displayed when using directly cx_oracle client. Connection statement is like this: cx_Oracle.connect(username, password,...

Here's what I did: I'm on Windows XP SP3 I already had Python 2.7.1 installed. I downloaded instantclient-basic-nt-11.2.0.3.0.zip, unzipped it, and put it in C:\Program Files\Oracle\instantclient...

In using cx_Oracle to invoke a simple stored procedure, I can easily get data back from the procedure as so: db = db_class() #Sets up stuff, etc. conn = db.connect() #Returns a connection to the d...

I'm attempting to connect to an oracle server in Python. I have this working in cx_Oracle, but when I try to connect using sqlalchemy it fails. The cx_Oracle code: import cx_Oracle import pandas a...

I try to connect to a remote oracle server by cx_Oracle: db = cx_Oracle.connect('username', 'password', dsn_tns) but it says databaseError: ORA-12541 tns no listener

I am trying to connect to Oracle using AWS lambda and python. These are the step I followed. (Everything has done EC2 instance) Downloaded the instantclient-basic-linux.x64-12.2.0.1.0.zip and in...

I am getting the error cx_Oracle.DatabaseError: ORA-00933: SQL command not properly ended when trying to run the following code. I have used import cx_Oracle ip = '127.0.0.1' port = 1234 SID = 'ab...

Here's my code: import cx_Oracle conn = cx_Oracle.connect(usr, pwd, url) cursor = conn.cursor() cursor.execute("UPDATE SO SET STATUS='PE' WHERE ID='100'") conn.commit() If I remove the conn.com...

I have this code where I am executing a select sql statement from python code using cx_oracle package: import cx_Oracle try: cur = conn.cursor() result = cur.execute('select * from table1') pr...

I've trying to create a list with the results from a column. I execute the query and the result are okay, but when I input the data in a list using list.append they return just []. import cx_Oracl...

As I understand it, there was some change related to SIP that makes installing this difficult. These pages have the background and advice to install. http://sourceforge.net/p/cx-oracle/mailman/mes...

I need install cx_Oracle for Python 2.5 on Linux (Linux 2.6.18-371.1.2.el5 i686). I have installed Oracle client 10.2.0.4. I have tried following: 1. Download cx_Oracle tar.gz from http://sourcefo...

I have installed Anaconda 3.5 for Windows 64bits, and I need to connect to the Oracle database using package "cx_Oracle". I tried with the anaconda way: conda install -c https://conda.anaconda.o...

I've been using the following function to make a "more readable" (supposedly) format for fetching data from Oracle. Here is the function: def rows_to_dict_list(cursor): """ Create a list, each ...

I'm getting the standard "DLL load failed; module not found" error when trying to import cx_Oracle. I have the proper instant client installed, the paths are all correct... running Dependency Walke...

I am a Python newbie, I am having troubles in the use of bind variables. If I execute the code below everything works fine. bind= {"var" : "ciao"} sql = "select * from sometable where somefield = ...

I'm using anaconda with Python3 I installed cx_oracle package using pip. When I type import cx_Oracle or run the code, the python interpreter recognizes the package and runs it, but for some rea...

I have a problem importing cx_Oracle with Python. I know a lot of issues with cx_Oracle have been discussed here, but it seems that I cannot find a solution to my problem after reading all the rela...

I'm trying to use cx_Oracle to connect to an Oracle instance and execute some DDL statements: db = None try: db = cx_Oracle.connect('username', 'password', 'hostname:port/SERVICENAME') #print(db....

I am on Windows 10 Pro 64-bit Anniversary Edition using Python 3.5.2 (Anaconda 4.1.1). I download the latest Oracle 12c Instant Client instantclient-basic-windows.x64-12.1.0.2.0.zip and instantclie...

I recently installed cx_Oracle module on my machine, in order to connect to a remote Oracle database server. (I have no Oracle client at my side). Python: Version 2.7 x86 Oracle: Verision 11.1....

I'm working with a database containing a lot of Chinese characters. My code goes something like this: connection = cx_Oracle.connect("%s/%s@%s:%s/%s" % (username, password, host, port, service_nam...

I have some monthly weather data that I want to insert into an Oracle database table but I want to insert the corresponding records in a batch in order to be more efficient. Can anyone advise as to...

I have two RHEL servers running Python 2.4 and 2.6 separately. There is an Oracle database on the other server I need to access. I was trying to install cx_oracle on my RHEL server but found out t...