Python stackoverflow Examples

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

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

Is it possible to bind variables to a SQLAlchemy query used in a Pandas.read_sql statement? Using %… Read more Binding Variables To Sqlalchemy Query For Pandas.read_sql

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

I am having a stored procedure in sql : PROCEDURE sp_add_object_tags( pi_account_id … Read more Call Stored Procedure Containing Collection Of Records Using Callproc In Python

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

I have a login, port number, host name and service name. How would I go about using the cx_Oracle.c… Read more How To Connect To An Oracle Database Using Cx_oracle With Service Name And Login?

I'm trying to write a Python script that will go through Rows and put them into my database Thi… Read more Parse Xml In Python And Add It To Database

I have an PL/SQL function my_function that returns custom defined object: CREATE OR REPLACE TYPE &#… Read more How To Get Custom Object From Callfunc In Cx_oracle?

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

i have 2 oracle client installed in linux machine. 10.2 and 12.2. Second one i have to use for cx_o… Read more How To Set Oracle Client Library Path In Python When Multiple Oracle Client Version Installed

I cannot get SQLAlchemy v. 1.3.22 with gevent 21.1.2 and cx_Oracle 8.1.0 to issue more than one que… Read more Sqlalchemy / Gevent / Cx_oracle Pool Size Stays At 1

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