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

Cx_oracle: Importerror: Dll Load Failed: The Specified Procedure Could Not Be Found

I have suddenly got a problem that I can no longer import cx_Oracle in python. I know that a lot of… Read more Cx_oracle: Importerror: Dll Load Failed: The Specified Procedure Could Not Be Found

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

How To Extend Oraclecursor Class From Cx_oracle

Using Python 2.7.12 and package cx_Oracle I'm trying to create an extended class of the what th… Read more How To Extend Oraclecursor Class From Cx_oracle

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

How To Fix Cx_oracle: Dll Load Failed?

There are so many related questions that I have gone through which made me wonder how come this is … Read more How To Fix Cx_oracle: Dll Load Failed?

Return A Stored Procedure Out Cursor Variable In Cx_oracle

I am trying to return a refcursor from a procedure in python using cx_oracle, my procedure looks so… Read more Return A Stored Procedure Out Cursor Variable In Cx_oracle

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

Sharing An Oracle Database Connection Between Simultaneous Celery Tasks

I'm working with Python2.7, Celery and cx_Oracle to access the Oracle database. I create a lot … Read more Sharing An Oracle Database Connection Between Simultaneous Celery Tasks