All Questions
Tagged with python-oracledb python
100 questions
-1
votes
1
answer
55
views
Clone data with new table in oracle using pandas
I am trying to clone SCOTT.EMP table with TEST table. However datatypes are not matching.
Please advise how to create a clone of EMP with new Table "TEST" with Same datatype in python pandas....
- 77
1
vote
1
answer
127
views
Executing and retrieving stored procedure returns in python with oracle db
I am trying to run
plsql = """
DECLARE
l_zip BLOB;
BEGIN
l_zip := apex_export.zip( ...
- 612
0
votes
1
answer
41
views
ETL from excel file to oracle database with same defined table
I’m working on a project where I need to automatically extract data from an Excel file and load it into an Oracle database. I’m using Python, TOAD, Oracle Client, and VS Code. The goal is to trigger ...
-1
votes
1
answer
60
views
In python: oracledb.connect simply hangs, even when the local client succeeds. Why?
I am trying to connect to an Oracle DB using the oracledb connection library and when I try it It simply hangs on with oracledb.connect even when following the documentation.
Here is the sample code. ...
- 5,692
0
votes
2
answers
34
views
bind parameters by array index
I'm trying to migrate from cx_Oracle 8.1.0 to oracledb 2.5.1 library. Before such query was working:
update command_center set
E_ID = :1,
E_ASPECTS = :2,
...
- 4,996
0
votes
0
answers
38
views
Pandas - decimal.InvalidOperation: [<class 'decimal.ConversionSyntax'>] during read_sql
I am running an extraction of a table in Python using Pandas. I am getting this error:
decimal.InvalidOperation: [<class 'decimal.ConversionSyntax'>]
The code:
dataframes[table] = pd.read_sql(...
- 9
0
votes
1
answer
188
views
Python : Not able to connect to oracle db ORA-12537: TNS:connection closed
I am trying to connect to oracle database in mac system.
My team generally works on Java so for development. we generally do this to connect to db in java. We connect to ssh tunnel which allows us to ...
- 45
2
votes
1
answer
1k
views
Python using oracledb to connect to Oracle database with Pandas DataFrame Error: "pandas only supports SQLAlchemy connectable (engine/connection)"
I am pretty new to Python and even newer to Pandas and am hoping for some guidance
My company has an on-prem DEV Oracle database that I am trying to connect to using Python & Pandas. After some ...
- 301
0
votes
2
answers
217
views
Connecting to Oracle SQL Database From Python Without cx-oracle
I need to run a SQL script from python (Jupyter) and need to connect to an existing Oracle database for the same. I am trying to automate the process, as the output of the SQL will serve as input for ...
- 47
0
votes
1
answer
53
views
dsnless connection using oracledb
Using VBA I can make a dsnless connection to oracle in the following way.
Driver={Oracle in OraClient21Home1};DBQ=<<string_returned_from_tnsping>>;User Id=fake_user;Password=fake_password;
...
- 77
0
votes
1
answer
843
views
Python-oracledb: DPY-6005: cannot connect to database (CONNECTION_ID=""). DPY-3008: unsupported in-band notification with error number 12572
I'm trying to connect to an Oracle database in Python using SQLAlchemy together with OracleDB. But I always get this error:
sqlalchemy.exc.OperationalError: (oracledb.exceptions.OperationalError) DPY-...
- 9
0
votes
2
answers
197
views
Pandas read_sql with SQLAlchemy from Oracle Database with many parameters
I have a working setup to read sql data into a pandas dataframe:
connect_string = f"DSN={config.DB};UID={credentials['UID']};PWD={credentials['pwd']};DBQ={config.DB_server};DBA=W;APA=T;EXC=F;FEN=...
- 593
-1
votes
2
answers
368
views
DPY-3008: unsupported in-band notification with error number 2396
I run a SQL query with a python script. i use python-oracledb library. same script works for other queries without error. i run query on Toad. there is no problem or error. i check the search engines ...
- 189
0
votes
1
answer
66
views
Python cx_oracle concurrent fetch
When using Python cx_Oracle - we set a parameter cursor.arraysize = 10000. I am assuming that this means the Python client running on the server receives data "sequentially" in batches of ...
- 325
0
votes
0
answers
119
views
Cannot get thick client on python oracledb working. Finds libclntsh.so - but fails at libnnz11.so
This is my python script.
import oracledb
import os
import sys
os.environ['ORACLE_HOME'] = "/home/ec2-user/linux_oracle_client"
os.environ['LD_LIBRARY_PATH'] = "/home/ec2-user/...
