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

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

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

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

How To Get Custom Object From Callfunc In Cx_oracle?

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?

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?