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

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

Error While Installing Cx_oracle On Windows

I am trying to install cx_Oracle module of python in my windows. I keep getting error below mention… Read more Error While Installing Cx_oracle On Windows

Extract Data From User Defined Type Via Cx_oracle

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

Binding Variables To Sqlalchemy Query For Pandas.read_sql

Is it possible to bind variables to a SQLAlchemy query used in a Pandas.read_sql statement? Using %… Read more Binding Variables To Sqlalchemy Query For Pandas.read_sql

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?

Sqlalchemy / Gevent / Cx_oracle Pool Size Stays At 1

I cannot get SQLAlchemy v. 1.3.22 with gevent 21.1.2 and cx_Oracle 8.1.0 to issue more than one que… Read more Sqlalchemy / Gevent / Cx_oracle Pool Size Stays At 1

Cx_oracle Sessionpool Root Of All Flask Problems

I created a web service in Flask over uwsgi. I thought I would follow good practice and create a S… Read more Cx_oracle Sessionpool Root Of All Flask Problems

How To Efficiently Load Mixed-type Pandas Dataframe Into An Oracle Db

Happy new year everyone! I'm currently struggling with ETL performance issues as I'm trying… Read more How To Efficiently Load Mixed-type Pandas Dataframe Into An Oracle Db

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

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

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

How To Correctly Call Fnd_concurrent.wait_for_request Stored Function Via Cx_oracle Module Api?

I am trying to perform wait for submitted request in Oracle by calling fnd_concurrent.wait_for_requ… Read more How To Correctly Call Fnd_concurrent.wait_for_request Stored Function Via Cx_oracle Module Api?

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

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

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

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?

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

How To Correctly Call Fnd_concurrent.wait_for_request Stored Function Via Cx_Oracle Module API?

I am trying to perform wait for submitted request in Oracle by calling fnd_concurrent.wait_for_requ… Read more How To Correctly Call Fnd_concurrent.wait_for_request Stored Function Via Cx_Oracle Module API?