# – This import requires appropriate oraocciXX.dll to be available in PATH (on windows) # (Probably LD_LIBRARY_PATH or LD_LIBRARY_PATH64 on POSIX) # where XX is the oracle DB version, e.g. oraocci11.dll for Oracle 11g. # – This dll is part of the Oracle Instant client pkg available here: # http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html # – Also ensure that … Read more
The easiest solution is as follows: Download 64-bit version of oracle instantClient from: https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html Copy the dll files in the instantclient directory to the python directory, as shown below That is it!
Here’s what I’ve come up with which appears to work well (but please comment if there’s a way to improve this): # build rows for each date and add to a list of rows we’ll use to insert as a batch rows = [] numberOfYears = endYear – startYear + 1 for i in range(numberOfYears): … Read more
I like to do it this way: ip = ‘192.168.0.1’ port = 1521 SID = ‘YOURSIDHERE’ dsn_tns = cx_Oracle.makedsn(ip, port, SID) db = cx_Oracle.connect(‘username’, ‘password’, dsn_tns) One of the main reasons I like this method is that I usually have a TNSNAMES.ORA file lying around someplace, and I can check that the dsn_tns object will … Read more
You are misusing the binding. There are three different ways of binding variables with cx_Oracle as one can see here : 1) by passing a tuple to a SQL statement with numbered variables : sql = “select * from sometable where somefield = :1 and otherfield = :2” cur.execute(sql, (aValue, anotherValue)) 2) By passing keyword … Read more