Skip to main content
140 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
1 vote
1 answer
339 views

I have FastAPI app, and its Dockerfile looks like this: FROM python:3.12-slim # Oralce dep WORKDIR /opt/oracle RUN apt-get update && apt-get install -y iputils-ping wget unzip libaio1 RUN wget ...
BeRightBack's user avatar
  • 238
2 votes
2 answers
71 views

I'm trying to update the CLOB attribute of a record type created using below script. I have 40,000 CLOB items, which I'm updating into 40,000 record type DB_TYPE_OBJECT via python code. Each record ...
omkar kothiwale's user avatar
  • 23
0 votes
1 answer
144 views

I'm using pyinstaller main2.spec command. The main2.spec file is the next: # -*- mode: python ; coding: utf-8 -*- a = Analysis( ['main.py'], pathex=[], binaries=[], datas=[ ('./...
Paul de la Cruz's user avatar
  • 1
0 votes
1 answer
79 views

I am facing issue in ODI14c Marketplace, while connecting to Oracle database using Python script. Error is, 'ObjectNotFound'. when i go and see, i can find oracledb package at location python3.8. ...
Raghu's user avatar
  • 1
1 vote
1 answer
89 views

Problems When using the "python-oracledb" client in Thin mode to store JSON data by direct binding, there is a problem with JSON type columns not being displayed on various clients. ...
Kazuma Kusu's user avatar
  • 15
0 votes
3 answers
84 views

I have a query wherein it has in clause. e.g. select * from table where column1 in ('value1', 'value2', 'value3'); I want to execute this query with list of (value1, value2 and value3, valueN) could ...
Praveen Mishra's user avatar
  • 175
0 votes
0 answers
21 views

Description: I am attempting to connect to the DW2_DEV database within our Oracle data warehouse using Python 3.11 and the oracledb library version 3.1.1. While I can successfully connect to the ...
b8con's user avatar
  • 629
0 votes
1 answer
357 views

I am trying to initialize python-oracledb in Thick Mode. It works on my Mac M1 Pro, but when I try to containerize my application with Docker, I get DPI-1047: Cannot locate a 64-bit Oracle Client ...
Simon1's user avatar
  • 788
1 vote
2 answers
92 views

So, i have been stuck with the connection timeouts happening from the PCF server. I am using oracledb.connect() and i'm fetching the role from the database. Until I restart the application in PCF it ...
Gracy Stephen's user avatar
  • 11
0 votes
1 answer
68 views

I am running an extraction of a table in Python using Pandas. I am getting this output: PS: The extraction works with other tables, this is happening with a specific one, but it's not the first time I ...
mrlelis's user avatar
  • 7
-1 votes
1 answer
75 views

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....
Veera V's user avatar
  • 135
1 vote
1 answer
224 views

I am trying to run plsql = """ DECLARE l_zip BLOB; BEGIN l_zip := apex_export.zip( ...
Sourabh's user avatar
  • 630
0 votes
1 answer
67 views

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 ...
Chibuzo Attah's user avatar
  • 1
0 votes
1 answer
41 views

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())....
Kamo Petrosyan's user avatar
  • 244
-1 votes
1 answer
182 views

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. ...
Christian Bongiorno's user avatar
  • 5,753
0 votes
0 answers
9 views

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 ...
Saravanan Radhakrishnan's user avatar
  • 1
0 votes
1 answer
62 views

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 ...
user2379881's user avatar
  • 93
1 vote
1 answer
125 views

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 ...
Kamo Petrosyan's user avatar
  • 244
0 votes
0 answers
25 views

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 ...
user2312787's user avatar
  • 19
0 votes
2 answers
51 views

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, ...
bilak's user avatar
  • 5,056
0 votes
0 answers
62 views

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 ...
user29692702's user avatar
  • 1
0 votes
0 answers
135 views

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 ...
Rohit Mewar's user avatar
  • 1
0 votes
1 answer
423 views

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 ...
Bhavin 's user avatar
  • 45
3 votes
1 answer
4k views

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 ...
chilly8063's user avatar
  • 309
0 votes
2 answers
522 views

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 ...
dskmrjt's user avatar
  • 47
0 votes
1 answer
59 views

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; ...
Z T Minhas's user avatar
  • 89
0 votes
1 answer
775 views

I have a Flask app that uses Flask-SQLAlchemy and the python-oracledb driver to interface with an Oracle database. I am attempting to run oracledb in thick mode so that I can enforce encryption ...
Dan Shepherd's user avatar
  • 3
0 votes
1 answer
1k views

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-...
mrlelis's user avatar
  • 7
0 votes
2 answers
254 views

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=...
Fred's user avatar
  • 603
-1 votes
2 answers
391 views

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 ...
Atacan's user avatar
  • 305
0 votes
1 answer
81 views

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 ...
Dinakar Ullas's user avatar
  • 345
0 votes
0 answers
156 views

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/...
Jevan has no idea's user avatar
  • 23
1 vote
2 answers
108 views

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. ...
MSuccessor's user avatar
  • 21
0 votes
0 answers
94 views

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 ...
user avatar
2 votes
2 answers
295 views

I installed a local database and used SQL Developer to create a test table. Database connection works, also the table is created and populated; example here Running this example code in Python throws ...
Arbiter Vildred's user avatar
  • 27
0 votes
1 answer
140 views

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 ...
privod's user avatar
  • 288
0 votes
1 answer
506 views

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 ...
Kazuma Kusu's user avatar
  • 15
0 votes
0 answers
493 views

I have a task to connect to an AWS RDS Oracle server and retrieve information using lambda layer. I have been working on this issue for almost two days. I discovered a lightweight Oracle database ...
user5820327's user avatar
  • 251
0 votes
0 answers
197 views

I have an Python application that connects to an Oracle Autonomous database. This application was working correctly until I had to migrate my Oracle Autonomous database from 23c to 23ai. The app ...
Jeremy's user avatar
  • 11
1 vote
0 answers
361 views

I am trying to connect to an oracle database using the python oracledb library. On looking at the docs it seems like python-oracledb doesn't have ldap support for thin mode. Is there a workaround for ...
Vardhan Gupta's user avatar
  • 165
0 votes
1 answer
214 views

I have a custom function on oracle database called create_identifier. It acccept a string and a column and concatenate the abbreviated form of the string to the column. I am trying to get the python ...
Isaac's user avatar
  • 25
2 votes
1 answer
635 views

Hi, i try to install superset with docker on ubuntu, but when i tried to connect with my oracle database i get this error. i already add RUN pip install cx_Oracle ini Dockerfile but still not work. ...
M ILHAMSYAH's user avatar
  • 31
1 vote
1 answer
580 views

I would like to set up an oracledb as a datasource but can't get the syntax. Is this even possible? import oracledb from sqlalchemy import create_engine import getpass username = getpass.getuser() ...
pybynumbers's user avatar
  • 194
0 votes
1 answer
187 views

I have the following piece of code where I read a csv file and connect to the database. then I want to pass two columns from CSV file as variable to my query and eventually convert the result to a pd ...
Avangard's user avatar
  • 31
0 votes
1 answer
302 views

I'm configuring my Oracle database to the django application using wallet.zip file in the following way. Note: This wallet.zip file contains tnsnames.ora file. In settings.py file: DATABASES = { ...
HARISH SOMSOLE's user avatar
  • 1
2 votes
0 answers
619 views

Summary:- we are pulling data from a oracledb performing a few operations and finally writing it back to oracledb in aws glue. While writing back to the oracledb we had to use the update statements ...
powerofthunder's user avatar
  • 41
0 votes
1 answer
163 views

I have a small Django application with an Oracle DB as database. I use "Django 5.0.3" with "oracledb 2.0.1". In "oracledb" library the object "connection" has a ...
rig's user avatar
  • 1
0 votes
1 answer
162 views

how to pass the array object? Here I have connected the Oracle DB through Python by using the Oracledb library #DB connection connection = oracledb.connect(user="hr", password=userpwd,dsn=&...
Learner's user avatar
  • 23
1 vote
1 answer
2k views

I am trying to read data from a local oracle database (Oracle Database 11g Release 11.2.0.4.0 - 64bit Production). I have created my own docker image: # Use the base Apache Airflow image FROM apache/...
Michael's user avatar
  • 223
1 vote
2 answers
919 views

When executing an Oracle SQL query from an application using a driver like python-oracledb, it is possible to bind variables by name or by position. Binding variables by name uses named arguments, and ...
DSL's user avatar
  • 121

1
2 3