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

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

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

Oracle Connection String With At Sign @ In Pasword

I have a code that connect to oracle using connection string: conn = cx_Oracle.connect('usernam… Read more Oracle Connection String With At Sign @ In Pasword

Python Oracle Insert Datatype Mismatch

I am trying to insert a dictionary into an Oracle table and its failing with data mismatch error. I… Read more Python Oracle Insert Datatype Mismatch

Call Stored Procedure Containing Collection Of Records Using Callproc In Python

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

Parse Table Names From A Bunch Sql Statements

I have an table with thousands of SQL statements in a column called Queries. Any ideas on how to ge… Read more Parse Table Names From A Bunch Sql Statements