152,640 questions
0
votes
0
answers
41
views
SQLcli project export using non-existent column on oracle-managed view
I am currently trying to start sqlcli project's structure on our oracle database to be able to use CI/CD pipelines.
Current steps:
I initialised sql project via
sql -thin /nolog
SQL> project init ...
Best practices
0
votes
7
replies
90
views
Best way to write an Oracle Procedure using Spring Data Jpa
I am new to JPA and learning it. Now I have an Oracle procedure in system, which now needs to be made DB Agnostic, that can run on Postgres. For that I want to write the same functionality of ...
- 503
0
votes
0
answers
53
views
invalid username/password logon denied using Oracle.ManagedDataAccess in Blazor Server App
I have Oracle XE running in a container, in which I can connect using the command:
podman exec -it oracle-container_oracle-db_1 sqlplus sap/sap@//localhost:1521/xepdb1
or simply (without specifying ...
- 12.8k
2
votes
0
answers
81
views
NUMBER(1,0) mapped to bool instead of int causes conversion and mapping errors
I'm connecting to an Oracle database using EF Core.
When scaffolding the database (Scaffold-DbContext), EF Core automatically maps columns of type NUMBER(1,0) to bool.
To avoid this, I changed the ...
- 21
0
votes
1
answer
60
views
Getting information on executed Oracle scheduler jobs? [closed]
Let's say I've created a stored procedure MY_ABC_PROC() and I schedule it to be ran thrice per day:
begin
dbms_scheduler.create_job(
job_name => 'MY_ABC_JOB',
job_type => ...
- 681
-4
votes
0
answers
102
views
Character “ is saving as ¿ in my Oracle database, the column is type NCLOB [closed]
Character “ is saving as ¿ in my Oracle database, the column is type NCLOB. I was using CLOB, I thought that using NCLOB will fix that issue, it is not!! Any route that anyone recommends? I really ...
- 737
0
votes
0
answers
44
views
Oracle.Web.Security.OracleRoleProvider fails with wallet-based TLS 1.2 connection on Windows Server 2012 R2 and 2022 (works locally)
Problem Summary
We’re currently blocked in production on OCI VMs (Windows Server 2012 R2 and 2022) when using Oracle.Web.Security.OracleRoleProvider to authenticate against an Oracle Autonomous ...
- 55
0
votes
1
answer
57
views
Where to define nested procedures in case when I need - variables + cursors + nested procedures?
I need to add 2 nested procedures into huge existing stored procedure.
But all my attempts fail with different errors.
Unfortunately, I cannot find in Oracle documentation - what is correct sequence ...
- 459
2
votes
1
answer
85
views
ORA-00904 when querying a sys.anydata column
Why am I getting a ORA-00904: invalid identifier error? How can I select the value of a sys.anydata column?
CREATE TABLE temp (
id NUMBER PRIMARY KEY,
val sys.anydata
);
INSERT INTO temp (ID, val)...
- 1,782
0
votes
1
answer
39
views
Reset APEX User Password [closed]
I am trying to reset the password for my APEX user account. I tried executing and committing the following update:
UPDATE wwv_flow_fnd_user
SET account_locked = 'N' , web_password = 'newpass',
...
- 1,461
1
vote
6
answers
218
views
Select data with self reference in where conditions
I work with a health insurance database.
tab1 contains data regarding drug dispensing. There is about one billion rows per months.
CREATE TABLE tab1
(
id NUMBER, -- patient id
dte DATE, -- ...
- 531
1
vote
2
answers
95
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,191
0
votes
3
answers
104
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.7k
2
votes
2
answers
98
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
1
answer
78
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