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

Tell Me How To Access Oracledb From Raspberry Pi Through Query

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

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

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

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

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

Python Cx_oracle Prepared Statement With Qmark

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

Problem With Select From Database If Using Unicode Character

I'm using latest version of python and robot framework with DatabaseLibrary (https://franz-see.… Read more Problem With Select From Database If Using Unicode Character

Python "dpi-1047 Cannot Locate Dlopen(libclntsh.dylib)" On Macos

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

Search For Name In Cx_oracle

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

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

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

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

How To Set Oracle Client Library Path In Python When Multiple Oracle Client Version Installed

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

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

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