All Questions
7 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
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
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
1
answer
717
views
connecting python to Oracle using sqlalchemy and oracledb
Need to connect to Oracle using Python that uses SQLAlchemy. I need to use the oracledb package.
Using code from
Github
import os
import oracledb
from sqlalchemy import create_engine
from sqlalchemy ...
0
votes
1
answer
711
views
Inserting INTO a Table with VARRAY data type column using python
I have a table that contains a varray data type column.
CREATE OR REPLACE TYPE updated_cols_type AS VARRAY(10) OF VARCHAR2(50);
CREATE TABLE "AUDIT"
("TABLE_NAME" VARCHAR2(100)...
0
votes
0
answers
693
views
python-oracledb thin client incorrect database timestamp
When I use thin client python-oracledb to get data from tables, which contains datetime columns with timestamp as "2022-10-15 14:35:09.000000 +00:00" I receive wrong timestamp like this &...
- 17