Skip to content Skip to sidebar Skip to footer
Showing posts with the label Cx Oracle

Cx_oracle Error Handling Issue

I'm trying to execute the following query in cx_Oracle but get the following error while execut… Read more Cx_oracle Error Handling Issue

Linux Profile.d Environment Variables Don't Work With Cx_oracle In Python

This is a bit of a continuation from my previous question: cx_Oracle does not recognize location of… Read more Linux Profile.d Environment Variables Don't Work With Cx_oracle In Python

Python: Connecting To An Oracle Database Using Oracle's Wallet/tnsnames

So I can connect to an Oracle database as such: import cx_Oracle as ora dsnStr = ora.makedsn(host=… Read more Python: Connecting To An Oracle Database Using Oracle's Wallet/tnsnames

Cx_oracle Does Not Recognize Location Of Oracle Software Installation For Installation On Linux

I have been able to successfully install cx_Oracle for use with Python 3.4 on my Windows 8 laptop, … Read more Cx_oracle Does Not Recognize Location Of Oracle Software Installation For Installation On Linux

Using Pd.read_sql() To Extract Large Data (>5 Million Records) From Oracle Database, Making The Sql Execution Very Slow

Initially tried using pd.read_sql(). Then I tried using sqlalchemy, query objects but none of these… Read more Using Pd.read_sql() To Extract Large Data (>5 Million Records) From Oracle Database, Making The Sql Execution Very Slow

Error While Installing Cx_oracle On Windows

I am trying to install cx_Oracle module of python in my windows. I keep getting error below mention… Read more Error While Installing Cx_oracle On Windows

Python "dpi-1047 Cannot Locate Dlopen(libclntsh.dylib)" On Macos

I am getting the following error. cx_Oracle.DatabaseError: DPI-1047: 64-bit Oracle Client library c… Read more Python "dpi-1047 Cannot Locate Dlopen(libclntsh.dylib)" On Macos

Loading Huge Xls Data Into Oracle Using Python

I have a 3+ million record XLS file which i need to dump in Oracle 12C DB (direct dump) using a pyt… Read more Loading Huge Xls Data Into Oracle Using Python