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

Cx_oracle.databaseerror: Ora-12170: Tns:connect Timeout Occurred

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

Python - Sqlalchemy - Oracle Connection Fails To Connect To Sid

I am trying to use sqlalchemy to connect to an oracle DB. I was expecting the following to work gi… Read more Python - Sqlalchemy - Oracle Connection Fails To Connect To Sid

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 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

Cx_oracle: Using Pl/sql Record Types As Arguments To Stored Procedures

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

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

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

Return The Number Of Affected Rows From A Merge With Cx_oracle

How can you get the number of affected rows from executing a 'MERGE INTO...' sql command wi… Read more Return The Number Of Affected Rows From A Merge With Cx_oracle

How To Pass A Python Array To An Oracle Stored Procedure?

I have a problem. When I pass a Python array: self.notPermited = [2,3] This is my procedure def se… Read more How To Pass A Python Array To An Oracle Stored Procedure?

How Do I Insert A Dataframe To An Oracle Table Illegal/variable Oracle

I have the following dataframe df2 = {names: [PEPE, LUIS], id: [1,2], stages: [0,1], ord: [3, 2]} … Read more How Do I Insert A Dataframe To An Oracle Table Illegal/variable Oracle

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

How To Connect To An Oracle Database Using Cx_Oracle With Service Name And Login?

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?

Cx_Oracle.DatabaseError: ORA-12170: TNS:Connect Timeout Occurred

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