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