132 questions
-1
votes
1
answer
54
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 ...
0
votes
1
answer
21
views
Call oracledb Connection.gettype from SQLAlchemy.AssyncSession
Have an async connection pool in FastApi application.
Using python-oracledb async connection pool (thin mode).
Trying to call Connection.gettype(name)
(await (await session.connection())....
- 244
-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
0
answers
9
views
Getting error while connecting to a oracle database from Science logic tool [duplicate]
I am getting the below error while trying to connect a oracle database from science logic tool.. What could be done to resolve this please..?
DPY-3015: password verifier type 0x939 is not supported by ...
0
votes
1
answer
33
views
ImportError for venv/lib64/python3.9/site-packages/oracledb/base_impl.cpython-39-x86_64-linux-gnu.so
I have a Django app that runs fine under runsslserver, but when I run it under Apache, the traffic gets to the app, but 'import oracledb' fails. I was using cx_Oracle previously (which also threw an ...
- 93
1
vote
1
answer
50
views
python-oracledb how to change arraysize for session
Stack:
oracledb==2.5.1
sqlalchemy==2.0.25
fastapi==0.105.0
How can I change Cursor's arraysize for a session? I Know how to set arraysize on createengine and it works for all connections in the pool
...
- 244
0
votes
0
answers
16
views
Flask app DB module avoiding circular import
I'm trying to avoid circular import at my Flask app (based on oracledb), but get "RuntimeError: Database pool not initialized". How can I properly handle the DB pool creation (create without ...
- 19
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
0
answers
38
views
Create table on Oracle using file created within the Python script
In my Python script, I have created a set of SQL statements in an output file. I would like to create a table using these SQL statements as my final output table on Oracle rather than run these SQLs ...
0
votes
0
answers
90
views
Python 3.8 | cx_Oracle 8.3.0 OR python-oracledb | executemany with batcherrors = True not working
I am using python 3.8 and cx_Oracle 8.3.0.
I am using executemany with batcherrors=True but it is not working at all.
executemany is just raising an exception for the error occurred at first place and ...
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