Questions tagged [oracle19c]
This tag is for questions which deal specifically with Oracle RDBMS version 19c. General question regarding the Oracle RDBMS product should use the `oracle` tag.
oracle19c
1,040
questions
0
votes
1
answer
19
views
Redirect to another page after downloading PDF file from REST api in Oracle Apex
I have an interactive report, in which a column is clicked and then a PDF file downloaded by calling a REST API. This column is a link to another page where Before page header process runs and ...
0
votes
0
answers
10
views
Application using OLEDB connection with Oracle 19.18c generating dumps
I'm facing an issue with my application that uses an OLEDB connection with Oracle 19.18c. The application is generating dumps, and so far, we haven't been able to determine the cause.
Details:
...
0
votes
1
answer
22
views
Oracle Apex REST response - PDF File not returning correctly
I have an REST API which take a PDF form and the data to fill this pdf form with. In response, pdf form with filled data is returned.
I have tested this API in Postman, work fine.
Now I am making a ...
0
votes
2
answers
23
views
SqlPlus works, but SqlDeveloper gives ORA-12505 TNS listener error when making a connection
I've installed Oracle 19c Enterprise on a Windows Server 2019. After installing, I used SQL Plus to connect as "SYS as SYSDBA" account successfully, and made queries etc.
However, when ...
1
vote
1
answer
36
views
Table result as a table parameter
I have a table with dates parameters PERIODS, and another one with dates and price PRICES.
I want to use dates from table PERIODS as parameters on PRICES, but to return zero when there is no date in ...
0
votes
1
answer
33
views
Oracle 19c ORA-02291 parent key not found
First time, long time. Love this place for finding answers to my dumb questions! Scarily, I'm Oracle self-taught (because it was thrown on my plate at work) and I have this occasional problem I simply ...
0
votes
2
answers
37
views
Oracle - Log the static SQL script which produced error inside PL\SQL procedure, into a table
I have some PL\SQL Procedures that execute static DML statements and use some pl\sql variables
in where clause.
For example:
procedure execute_insert is
l_parameter varchar2(100);
...
1
vote
2
answers
58
views
How to fetch records having difference of 5 minutes or less | Oracle
I am currently stuck with this approch not getting how do i need to minus with current timestamp and find all records which as a difference of 5 minutes or less
My table
create table demo ( id number, ...
0
votes
1
answer
44
views
Create date periods based on two tables
CREATE TABLE "TEST1"
(
"ID" NUMBER(9,0) NOT NULL ENABLE,
"DATE_FROM" DATE,
"DATE_TO" DATE
);
CREATE TABLE "TEST2"
(
"...
0
votes
2
answers
38
views
ORA-00937 when reading a group by subquery
I am relatively new to Oracle Db, and this might be something stupid, but I cannot find what is the problem with this query. I get ORA-00937: not a single-group group function when I run it.
select a....
1
vote
2
answers
86
views
Moving data between two partitioned tables in Oracle 19c
I am trying to move data between two partitioned tables. Below is the sample script. I am working on Oracle 19c and using 12c feature of creating table for exchange. Please suggest what is missing.
...
0
votes
2
answers
43
views
Update a BLOB column with data of length 80,000 chars in Oracle 19c
We have a requirement to update a BLOB column (which stores JSON data and has a JSON constraint) enabled. The issue is with the length of the data that the BLOB data needs to be updated with. It is ...
0
votes
1
answer
58
views
Generate Nested JSON oracle19c using JSON functions
Hi I have below sample query.In real case scenario there are many more columns in each view.
The A view has unique ids and is present in other views. I tried to join all the views and generate JSON ...
0
votes
0
answers
29
views
Automatic Subpartition in Oracle
I have a table which is partitioned on ts_date ( Interval partition) now requirement is to create sub partition on run_id column which is being populated from sequence.
For one ts_date there may be 10 ...
0
votes
0
answers
12
views
Getting Listener issue during deployment of Oracle via kustomize
pod is encountering an issue where it cannot connect to the Oracle Database listener. Tets pod stuck in Error state and when I saw logs I am getting this logs with erros :-
[ec2-user@ip-10-211-28-63 ...