Oracle Application Express version 18.2, released Sept 2018.
Use this tag in addition to oracle-apex if your question is specifically related to Oracle APEX version 18.2.
Questions tagged [oracle-apex-18.2]
111 questions
4
votes
1 answer
Open a modal page inside another modal page without closing parent modal page in oracle apex 20.1
I have two modal pages not inline modal pages those are two separated pages page A and page B. Inside page A there is a link to open page B. When open page B, page A will be closed. How do I avoid it.? I open the page B with option "Redirect into…
Pumayk26
- 537
- 10
- 28
3
votes
1 answer
How to display trailing whitespace in Interactive Report
I'm using an Oracle APEX 18.2 interactive report to display some data of type NVARCHAR2 in an APEX column of type "Plain Text." Some data includes trailing spaces. When I view the interactive report, the trailing spaces are not shown. How can I…
Steve Hart
- 859
- 1
- 5
- 13
2
votes
1 answer
Are all applications developed with versions prior to 20.1 vulnerable?
I have a restaurant management system with many pages with forms and interactive grids to create documents like sales invoices, return goods, etc... . The problem arises when user clicks the submit button many times quickly by mistake or…
Eslam
- 323
- 3
- 20
2
votes
0 answers
How to ajax refresh a region in ORACLE Apex - based on a selection in a Badge List [Plugin]
I have a badge list plug in returning a few items:
SQL for the badgel list plug-in is below:
WITH
STUDY_MV AS
(
SELECT /* MATERIALIZE */
* FROM VW_GRET_CTA_STUDIES
WHERE GRET_ID = :P14_GRET_ID
AND STUDY_CODE = :P14_STUDY_CODE …
smackenzie
- 2,880
- 7
- 46
- 99
2
votes
4 answers
human readable URLs in Oracle APEX
how to make human readable URLs in oracle apex
currently my url seems like
https://example.com/apex/f?p=107:1:13482402024834:::::
what i want my database application url looks like.
https://example.com/apex/home
i am using oracle apex 18.2
AbdulRaheem
- 115
- 2
- 15
1
vote
1 answer
oracle apex current version 4.0 we can upgrade latest version 22.2
Please see below details for Apex:
Current is: DB 11.2.0.2.0 and APEX version 4.0
Linux server
It's opensuse 13.2. Very old version
32GB ram, 8 core CPU and 2TB
On a virtual machine.
Required
Database version – 21c
Apex version – We want to use…
amol bhosale
- 13
- 2
1
vote
1 answer
Oracle Apex set select list value in session state without submit page on change
How save selected value from select list in session state without submit page on change?
Example work with submit page!
babayaro
- 491
- 3
- 15
1
vote
1 answer
Oracle Apex - check all items in classic report - more than one classic report on page
On a page I have two classic report in different tabs.
I'm adding options: check all
eg.
In classic report query column
apex_item.checkbox2(1,country_id) checkbox_ID
On Heading column checkbox_ID
Function and…
user_odoo
- 2,284
- 34
- 55
1
vote
2 answers
Oracle Apex Interactive Report - cell background color
Is it possible remove white space (padding) inside cell?
Query return cell background color like this:
Select
'' || col_1 || '' as "1",
'' || col_2 || ''…
user_odoo
- 2,284
- 34
- 55
1
vote
1 answer
Bind label from computation - oracle apex
I try bind label text from computation but I don't know how render html.
When put in label static html work fine.
Eg.
Any solution how fix this problem?
user_odoo
- 2,284
- 34
- 55
1
vote
1 answer
APEX Collection Loading in Pre-Rendering Process: Error: WWV_FLOW_COLLECTIONS_UK
I am running a delete/creation of an APEX Collection from pre process (code below) and am running into the following error once in a blue moon.
I saw a couple posts on this error, but they seem to be related to a different issue. There were some…
theCJCsoccer
- 601
- 8
- 29
1
vote
1 answer
make a GET request using APEX
this question is simple.
¿Why i can't use the next code?
select apex_web_service.make_rest_request(
--p_url => 'https://api.exchangeratesapi.io/history?start_at=2018-01-01\&\end_at=2018-09-01',
p_url =>…
Julio
- 471
- 5
- 20
1
vote
2 answers
How to create a HTML table with the dynamic columns with the dynamic rows from the query in oracle
My code:
Declare
l_body CLOB;
l_body := ''
||''
|| '
user10777723
1
vote
1 answer
Interactive Grid - JavaScript getValueI’m struggling to obtain the new value that is being set in an editable Interactive Grid. I’ve created a dynamic action to be fired when the column has changed. The dynamic action is firing as expected, but it’s returning the previous value and not…
hisnameismyname2
1
vote
1 answer
Which model notifications should I listen to in order to calculate the sum of an IG column?I am using Apex 18.2. I have a page with an interactive grid with a column "Total" whose sum value should get calculated through looping over the model whenever the sum changes for example, when a new row is created, a row is deleted, a row column's…
Eslam
|
|---|