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

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

Dpi-1047: 64-bit Oracle Client Library Cannot Be Loaded

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

Wrong Number Or Types Of Arguments In Call To Procedure With Use Zxjdbc

I took official example from http://www.jython.org/archive/21/docs/zxjdbc.html: Oracle >>>… Read more Wrong Number Or Types Of Arguments In Call To Procedure With Use Zxjdbc

Can't Properly Read Sql Table In Python: Varchar Columns Imported As Comma-separated Characters / Tuples

I'm connecting to a Oracle database using the following code: jar = ojdbc8.jar path jvm_path = … Read more Can't Properly Read Sql Table In Python: Varchar Columns Imported As Comma-separated Characters / Tuples

Return A Stored Procedure Out Cursor Variable In Cx_oracle

I am trying to return a refcursor from a procedure in python using cx_oracle, my procedure looks so… Read more Return A Stored Procedure Out Cursor Variable In Cx_oracle

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

How To Export Parsed Data From Python To An Oracle Table In Sql Developer?

I have used Python to parse a txt file for specific information (dates, $ amounts, lbs, etc) and no… Read more How To Export Parsed Data From Python To An Oracle Table In Sql Developer?

Cx_oracle - Dll Load Failed: %1 Is Not A Valid Win32 Application. Python

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

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

Is There A Way To Use FORALL To Insert Data From An Array?

I am running oracle 19c and I want to get the best insert performance I can. Currently, I insert us… Read more Is There A Way To Use FORALL To Insert Data From An Array?

How To Retrieve Result Of Oracle Database Function Via ODBC?

I have problem with calling Oracle stored function (not procedure) via ODBC. My function is really … Read more How To Retrieve Result Of Oracle Database Function Via ODBC?

How To Connect To Database Using QOCI Or QODBC With Correct Encoding?

I want to connect to Oracle database using PyQt5 QOCI driver. Here is some example code I'm usi… Read more How To Connect To Database Using QOCI Or QODBC With Correct Encoding?

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

Cx_Oracle Connection Timeout

I am trying to connect to Oracle database but getting below error: curcon = cx_Oracle.connect(conn… Read more Cx_Oracle Connection Timeout