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

Pyspark: Cx_oracle.interfaceerror: Not A Query

i need to perform update query in spark job. i am trying below code. but facing issues. import cx_O… Read more Pyspark: Cx_oracle.interfaceerror: Not A Query

Set Database Connection Timeout In Python

I'm creating a RESTful API which needs to access the database. I'm using Restish, Oracle, … Read more Set Database Connection Timeout In Python

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

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

Extract Data From User Defined Type Via Cx_oracle

I am trying to extract data from User defined type (UDT) via cx_Oracle. Here is the UDT structure: … Read more Extract Data From User Defined Type Via Cx_oracle

Cx_oracle With Multiple Oracle Client Versions

I am running Python 2.7 and am using cx_Oracle on a linux 64 bit OS. I need to be able to run agai… Read more Cx_oracle With Multiple Oracle Client Versions

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

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