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]
112 questions
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
- 93
- 11
2
votes
0 answers
Interactive Report - Sort and filter formated column
I have a simple view which holds a duration in seconds as a number and a formated string as the other column
The numbers can be negative and are "formated" like this:
-60 is -00h 01m 00s
60 is +00h 01m 00s
and so on....
To sort my data, I formated…
Benjamin Weiss
- 3,206
- 2
- 37
- 87
2
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
- 70
- 1
- 8
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,476
- 3
- 29
- 79
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
- 404
- 6
- 24
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
- 367
- 1
- 14
1
vote
1 answer
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
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
1
vote
0 answers
Automate Oracle Apex page layoutCan I automate or adjust oracle apex page layout and not individual region. I have a page where multiple regions are there and one region is master region, I want to set something on the page itself at horizontal scrollbar region by region doesn't…
Anshul Ayushya
1
vote
1 answer
Oracle Apex: DA That Will Fire On Close of Modal Dialog?I have a pretty ordinary single-page Oracle Apex application. For my main-page template, I just started from a blank page.
Under certain conditions in this Apex application, based on end-user entry, I have processing defined which branches to…
Tebbe
1
vote
1 answer
Oracle APEX: Reset session on every application launch?My use case is actually from the standpoint of an Oracle APEX developer. I'm on version 18.2.
I am working on a single-page application. Every time I run my APEX application from Page Designer, I want the session state of my application to…
Tebbe
1
vote
0 answers
String index out of range oracle bi publisherI'm download .xml from Oracle apex > Shared Components > Report Queries and open with oracle BI addon in MS Word. XML is successful loaded I'm add header text and change column name and save as .RTF file.
After import .RTF file in Oracle apex >…
Pointer
1
vote
1 answer
Two event on one button click Oracle ApexFirst I have loop in pl/sql example (EX 1)
begin
declare
l_string varchar2(4000);
begin
:P15_URL_PARAMETER := '';
FOR i IN 1..APEX_APPLICATION.G_F01.COUNT LOOP
l_string := l_string || APEX_APPLICATION.G_F01(i) ||…
Pointer
1
vote
2 answers
Oracle Apex - Password expire after set date based on table and Login validationI trust you are well. Here's the breakdown of what I got so far. I have:
Custom authentication schema, referencing username and password from table. (works)
I've added an expire_password column which I would like to set a trigger or function (not…
Thembani Mbambo
1
vote
2 answers
Is it possible to run Apex on other then database server?Is there anyway to run apex on application server while having database on another server. I meant to say that I want to make one database server in which oracle database will be installed and another application server on that apex will be…
Muhammad Irfan
|
|---|