All Questions
Tagged with oracle-database python-oracledb
85 questions
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
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
91
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
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
1
vote
2
answers
89
views
SQL command works fine when run manually (SQL Developer) but gives ORA-00922 in Python's oracledb module
I am working with an Oracle SQL database, and I would like to run the command
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD';
It works fine when I run it from the SQL Developer app manually. ...
- 21
0
votes
0
answers
79
views
data migration (georeferenced data) from oracle to postgres
First, the Python code should connect to an Oracle database and store the retrieved data using the pandas library. Then, a connection to the relevant PostgreSQL database will be established. A table ...
user8044707
0
votes
1
answer
122
views
Send a rowtype variable to a procedure using oracledb
I have oracle package ETL_RUN, in the package there is a procedure which is declared like this:
procedure pRunTask(pTask in out nocopy TASK_RUN%rowtype)
I am trying to call the procedure from Python ...
- 278
0
votes
1
answer
335
views
Error in Direct Binding of JSON Data with python-oracledb Library on Oracle Database 23ai
I tried to load JSON data using direct binding as described in this example. I encountered the error oracledb.exceptions.NotSupportedError: DPY-3002: Python value of type "dict" is not ...
