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

How To Connect To An Oracle Database Using Cx_oracle With Service Name And Login?

I have a login, port number, host name and service name. How would I go about using the cx_Oracle.c… Read more How To Connect To An Oracle Database Using Cx_oracle With Service Name And Login?

Return The Number Of Affected Rows From A Merge With Cx_oracle

How can you get the number of affected rows from executing a 'MERGE INTO...' sql command wi… Read more Return The Number Of Affected Rows From A Merge With Cx_oracle

How To Execute A Raw Query With Returning In Sqlalchemy

I have a table Ticket that has the id (autoincremental), ticket_number (trigger that reads a sequen… Read more How To Execute A Raw Query With Returning In Sqlalchemy

Python "dpi-1047 Cannot Locate Dlopen(libclntsh.dylib)" On Macos

I am getting the following error. cx_Oracle.DatabaseError: DPI-1047: 64-bit Oracle Client library c… Read more Python "dpi-1047 Cannot Locate Dlopen(libclntsh.dylib)" On Macos

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

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

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

Oracle Connection String With At Sign @ In Pasword

I have a code that connect to oracle using connection string: conn = cx_Oracle.connect('usernam… Read more Oracle Connection String With At Sign @ In Pasword