Python Playground

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

The problem is the link between raspberry pie and Oracle database. We've tried a lot of things … Read more Tell Me How To Access Oracledb From Raspberry Pi Through Query

I am trying to run oracle database in python. Specifications: 1. Windows 7 64 bit 2. Python 32 bit … Read more Dpi-1047: 64-bit Oracle Client Library Cannot Be Loaded

I'm attempting to call AP_VENDOR_PUB_PKG.CREATE_VENDOR from cx_Oracle (This is an Oracle R12 st… Read more Cx_oracle: Using Pl/sql Record Types As Arguments To Stored Procedures

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

I am trying to get a oracle sqlalchemy dburi working with an external password store (Oracle Wallet… Read more Using Sqlalchemy Dburi With Oracle Using External Password Store?

I have: win 7 (64 bit) python 3.4 oracle 64 bit After I downloaded and installed from here the c… Read more Cx_oracle - Dll Load Failed: %1 Is Not A Valid Win32 Application. Python

Is there a module for python 3.3 to connect with Oracle Databases? Which is the easiest to use? Som… Read more Python 3.3 - Connect With Oracle Database

I have var='smth' and I need to check if var exists in the table 'smtb' I tried som… Read more Search For Name In Cx_oracle

I have two lists where I want to left join one. This is how I generate the first list: # NB Oracle … Read more Trouble With Left Joining Tables Pandas (valueerror: You Are Trying To Merge On Object And Int64 Columns.)

This is my code: import urllib import requests from bs4 import * from subprocess import Popen,PIPE… Read more Subprocess Gives An Error. "the System Cannot Find The File Specified"

I am getting cx_Oracle.DatabaseError: ORA-12170: TNS:Connect timeout occurred error while connecti… Read more Cx_oracle.databaseerror: Ora-12170: Tns:connect Timeout Occurred

I am trying to work with cx_Oracle, but it seems to dislike what I know about db-api. These stateme… Read more Python Cx_oracle Prepared Statement With Qmark

I am trying to connect to oracle on rds using lambda with python using cx_oracle package but i get:… Read more Aws Python Lambda With Oracle - Oid Generation Failed Even After Adding Hostaliases

This is mainly just a 'check my understanding' type of question. Here's my understandi… Read more Help Me Understand The Difference Between Clobs And Blobs In Oracle

I am trying to log the pyodbc exception to a log file, the problem is, using the standard python lo… Read more Pyodbc Exception Args Has Some Unidentified Characters

I have var='smth' and I need to check if var exists in the table 'smtb' I tried som… Read more Search For Name In Cx_Oracle

I have a table such as the following: **ID tDate Product Price Quantity BuySel… Read more Compare Rows In Oracle Table And Update Matching Ones