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

Amazon Python 2.7 Lambda: Dpi-1047: 64-bit Oracle Client Library Cannot Be Loaded: "libclntsh.so"

This article was the closest to what I experienced: Connecting to Oracle RDS using AWS Lambda using… Read more Amazon Python 2.7 Lambda: Dpi-1047: 64-bit Oracle Client Library Cannot Be Loaded: "libclntsh.so"

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

Help Me Understand The Difference Between Clobs And Blobs In Oracle

This is mainly just a 'check my understanding' type of question. Here's my understandi… Read more Help Me Understand The Difference Between Clobs And Blobs In Oracle

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

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

Python 3.3 - Connect With Oracle Database

Is there a module for python 3.3 to connect with Oracle Databases? Which is the easiest to use? Som… Read more Python 3.3 - Connect With Oracle Database

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

Loading Dataframe From Pandas To Sql For Oracle Yields And Error - Ora-00911: Invalid Character

I am attempting to load a dataframe from Pandas to Oracle. I can read_sql just fine, but df.to_sql … Read more Loading Dataframe From Pandas To Sql For Oracle Yields And Error - Ora-00911: Invalid Character

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?

Python 2.7 Connection To Oracle: Loosing (polish) Characters

I connect from Python 2.7 to Oracle data base. When I use: cursor.execute('SELECT column1 FROM … Read more Python 2.7 Connection To Oracle: Loosing (polish) Characters

Application Vs Database Resident Connection Pool

Situation: I have a requirement to use connection pooling while connecting to Oracle database in p… Read more Application Vs Database Resident Connection Pool

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

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

Connection Timeout Parameter For Oracle Db From Python

I am using the below simple code to connect to Oracle database to execute a stored procedure. But a… Read more Connection Timeout Parameter For Oracle Db From 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?

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

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

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?