Oracle Application Express version 19.2 - released Nov 2019. Superseded in Apr 2020 by version 20.1.
Use this tag in addition to oracle-apex if your question is specifically related to Oracle APEX version 19.2.
Useful links
Questions tagged [oracle-apex-19.2]
87 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
2
votes
1 answer
Oracle Apex - A lot of session with nobody user
I have a lot of session with nobody user. Any solution how stop this.
Page 9999 is login page, page 2 is default (home page) after login.
user_odoo
- 2,284
- 34
- 55
2
votes
1 answer
Oracle apex apex_application.g_f0x don't get table items
I have a report with apex_item(s). The report is complicated so I show only what is relevant for simplification.
The report is created with:
select ID || apex_item.hidden(11,ID) as "ID",
apex_item.text(p_idx => 12, p_value => VOLUME) as…
Izik
- 746
- 1
- 9
- 25
2
votes
1 answer
Interactive Grid - adding filter for more than one value
I am setting a filter for an IG for Field1 equals 'My Value1'. It works fine but now when I try to add another value to the filter I use Field1 IN 'My Value1', 'Test', whatever was displayed with one filter disappears. I also tried Field1 IN 'My…
Coding Duchess
- 6,445
- 20
- 113
- 209
1
vote
1 answer
Refresh the page item after saving the Interactive grid
After saving the Interactive grid, I need to Refresh the page item (Display only). How to achieve this
shajin
- 29
- 4
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
1 answer
Oracle apex open file browser automatically on page load
I need to open "File Browse" item ("P50_BLOB") on page load.
I tried clicking the item with dynamic action on page load with javascript:
$('#P50_BLOB').click();
it didn't work, though it does work using the console.
I have also tried using async /…
Izik
- 746
- 1
- 9
- 25
1
vote
0 answers
Download XMLTYPE data as XML file on Oracle Apex page
My view return XMLTYPE, DATA column contains xml documents.
Is it possible on oracle apex page on button click, on page load or other way download this as eg. TEST.XML file
When load query in classic report and set Atributes > Apperancees >…
babayaro
- 491
- 3
- 15
1
vote
2 answers
Oracle Apex inconsistent asterisk side
We found out that on different fields on the page the asterisk of a required field is sometimes left to the text and sometimes right to the text.
I'm talking only about the Appearance-->template-->Required and not about…
Izik
- 746
- 1
- 9
- 25
1
vote
1 answer
Oracle Apex difference between css classes in item
each item in Oracle Apex got 3 "CSS Classes" attributes.
One in "Layout" section, one in "Appearance", and the other in "Advanced".
I've tried to use them all, and can't see any difference. Is there one?
Thanks
Izik
- 746
- 1
- 9
- 25
1
vote
1 answer
Oracle Apex save pasted image into blob
I found the way here, how to copy a clipboard image to a region, ad it works well. But I didn't find how can I save this picture into my blob field. Which variable contains the image (maybe it is a javascript variable), and how can I refer to it in…
Ajtony Varga
- 23
- 5
1
vote
2 answers
Issues with Web source module POST request Oracle APEX
I am in the process of calling Okta API for Authentication "Primary Authentication" as shown in the pic below and I tested this using post man and it was working as expected with proper response.
I am trying to integrate this API call out with APEX…
Ashlesh Kumar
- 79
- 8
1
vote
1 answer
Oracle Apex - BLOB to jpg
I'm trying to pass a jpg that I have stored in a table as a blob to the following javascript code:
class ImageLoader {
constructor(imageWidth, imageHeight) {
this.canvas = document.createElement('canvas');
this.canvas.width = imageWidth;
…
Anjoys
- 89
- 10