152,665 questions
0
votes
2
answers
51
views
Issue with compiling PL/SQL: invalid relational operator
Environment Oracle 19c (also 12c)
Here's my code:
CREATE OR REPLACE TRIGGER ClientTime
AFTER INSERT OR UPDATE OR DELETE ON ClientTime
FOR EACH ROW
DECLARE
v_pk_json CLOB;
v_changed CLOB;
...
- 6,171
0
votes
0
answers
50
views
Invalid parameter binding -: Invalid ParameterName while using bulk inserts with SSIS and C# to Oracle
I'm using a C# script component with SSIS datflow to insert rows in batches. This is the code I use, but I'm getting this error:
Invalid parameter binding
Parameter name: ParameterName
These are the ...
-2
votes
0
answers
37
views
ADF Oracle connector 2.0 is very very slow compared to v1.0 [closed]
I have an ADF pipeline that copies the data from the Oracle server to ADLS. One of the table is very huge with 500 million records. When I am using v2.0, I noticed that it's taking forever to copy the ...
- 435
-3
votes
1
answer
61
views
Bringing together results of two different SQL data given certain criteria [closed]
I am attempting to clean up our database and clearing out old records and that are not used. Primarily deleting any user ids that are not set on any file record in the system.
I have three tables,
...
- 13
0
votes
3
answers
90
views
Allocate value to a constant column with a group of multiple rows
I have data in a table like this:
columnA here is constant value within the group of rows with columnB consisting of id's 1,2,3,4
I am trying to write a SQL query to allocate the value of the columnC ...
- 67.6k
-4
votes
0
answers
32
views
How to plot 2 million row lat/long dataset on map of India in Apache Superset without hitting row limit? [closed]
I’m working with Apache Superset and need to visualize a 2 million rows geospatial dataset containing latitude and longitude columns.
In Tableau, I can easily plot this entire dataset on a map without ...
-3
votes
0
answers
26
views
Issues with Simulator Deployment in OBDX 22.1 and Server Startup in OBDX 22.2 [closed]
🔹 Issue 1: Simulator WAR Not Deploying in OBDX 22.1
In our OBDX 22.1 setup for a third-party host, we are attempting to use the digx-extxfacesimulator.war to simulate dummy data and perform retail ...
2
votes
2
answers
80
views
javax.sql.rowset.serial.SerialClob cannot be cast to oracle.sql.CLOB while using preparedStatement.setClob
I'm trying to insert a java.sql.Clob to an Oracle DB table with a clob column and it fails with the following exception
javax.sql.rowset.serial.SerialClob cannot be cast to oracle.sql.CLOB
at ...
- 133
0
votes
0
answers
59
views
writing changes to two databases during Oracle to Postgres migration [closed]
I am using Oracle for production, and need to migrate to Postgres with no downtime. I figured out that I can follow the 4-step? approach for the migration.
First, write changes to both databases, and ...
0
votes
2
answers
50
views
Oracle 19c, Timestamp, Timezone [closed]
The result of the following statement does not appear to be accurate or correct.
select(to_timestamp_tz('2025-10-02 08:24:00', 'yyyy-mm-dd hh24:mi:ss')at time zone 'Europe/Berlin')-(to_timestamp_tz('...
- 31
0
votes
1
answer
34
views
ADF Oracle Linked Service 2.0 performance issue with CLOB column [closed]
For a project I’m upgrading the Oracle linked service from V1 to V2. Now we have a big performance issue.
We are loaded data from an Oracle datasource to Parquet-files on a BLOB. For 1 specific job we ...
- 11
-1
votes
0
answers
42
views
Connect Oracle Forms & Reports 6i with Oracle Database 11g [closed]
I installed an Oracle 11g R2 database, and I have an application based on Oracle Forms & Reports 6i.
When I install Oracle under E:\ORACLE and Forms 6i under E:\ORANT, the following problem occurs:...
-1
votes
0
answers
32
views
DMS replication error with self managed oracle as a source [closed]
I'm triying to use cdc replication from self managed oracle 19.c to S3. Full load works but CDC keeps tables in before load state and I see this in the logs:
025-10-07T15:16:40.000Z
2025-10-07T15:16:...
- 1,470
-2
votes
0
answers
46
views
Oracle SubProcedure [closed]
I used to run subprocedures in packages with parameters. But now I want to create a new one without parameters. I don't know why but it doesn't work. Please help:
create or replace PACKAGE BODY ...
- 13
1
vote
2
answers
117
views
SQL unquoted identifier validation
I'm working on a .NET application that needs to execute SQL parameterized by database objects like tables or columns. The application supports both the Microsoft SQL Server and Oracle ADO.NET ...
- 67