7,107 questions
0
votes
1
answer
19
views
How can I prevent add duplicate items to APEX_COLLECTION
I want to create laboratory tests order and I created apex collection ,
I need to check if test already exists in the collection I need to show message says
Test already exists .
I tried this code :
...
- 1,001
0
votes
1
answer
23
views
Oracle Apex Server-side Code do not set item
I want to make simple region: input field, button to send request to DB and read-only field to display result.
Here are the PL/SQL Code:
begin
select
edrpou || '; ' || nameorg || '; ' || ...
- 75
-4
votes
1
answer
42
views
How to select today date and time in date picker field by default
How can I select today date and time in oracle apex form field Date picker by defult,
I tried to select default value but its not show when open the form in update mode
I tried first choice static ...
- 1,001
0
votes
1
answer
22
views
How to Show the History Details of Oracle Apex Application Changes?
Are there any way to show the details of changes during the development process of page components on oracle apex. I see the Monitor Activity feature but it not shown details like the report source ...
- 110
1
vote
2
answers
36
views
how to use dynamic SQL in Application Express
I'm trying to figure out how to use dynamic SQL in Application Express.
I have a field called SQL TEXT where users will be able to pass some commands, like SELECT, for example.
And below, there is a ...
- 11
0
votes
1
answer
27
views
How to import and migrate the checked checkbox in Oracle APEX
Hi I am using the Oracle APEX to build an application to register the records in my company.
The aim of the app is to register the issues when spotted during sales.
We have the checkbox that when ...
- 315
1
vote
0
answers
31
views
Conflict config java (jvm) variable of Environment when install jasper integration
i install oracle apex in my pc and install java
i set this variable in Environment
Name : '''JAVA_TOOL_OPTIONS'''
value : '''-Dconfig.url=C:\Oracle\ords'''
but when i install jasper apex integration ...
- 41
0
votes
0
answers
34
views
ORA-24247: network access refused by access control list (ACL) [closed]
ORA-29273: échec de demande HTTP
ORA-06512: à "APEX_190100.WWV_FLOW_WEB_SERVICES", ligne 1035
ORA-24247: accès réseau refusé par la liste de contrôle d'accès (ACL)
ORA-06512: à "SYS....
0
votes
1
answer
35
views
Automating Google Analytics Data Extraction to Oracle APEX Database
I'm looking to automate the extraction of Google Analytics data into an Oracle APEX database table without user interaction. I've successfully tested the API (POST https://analyticsdata.googleapis.com/...
- 1
0
votes
1
answer
32
views
What is proper JSON selector to extract information in proper way?
I am trying to consume external API in Oracle Apex. API returns JSON like this:
{
"key1": "value1",
"key2": "value2",
"key3": "value3",...
- 75
0
votes
0
answers
30
views
Change column value based upon if there is a new entry in interactive grid apex 24.1
I am an absolute newby to JavaScript and I am trying to change the value of column ZEILE_STATUS to 'T0' if a new entry is made in the grid and the value of this column to 'T' for all the following ...
- 1
0
votes
2
answers
37
views
Conditionally Formatting background color for Interactive Report Cells of type link
I have to color certain cells within my Interactive Report Region based on a hidden column value. I started by following this article and many others with similar information here but this doesn't ...
- 97
1
vote
1
answer
59
views
Custom Event not triggered on Modal Dialog Page
one of classic Report columns setted to be link and its javascript link which is javascript:$.event.trigger({type:'customEvent',id:'#ID#'});
Dynamic Action created with the following attributes:
When: ...
- 110
0
votes
1
answer
41
views
Page items values do not refresh in static content region
I have static content region with HTML
<a href="f?p=&APP_ID.:1:&APP_SESSION.:APPLICATION_PROCESS=GET_FILE:::FILE_ID:&P12_FILE_ID.">Download &P12_FILE_NAME.</a>
...
- 75
0
votes
1
answer
40
views
How to hide option "Fill", "Clear", "Copy Down" from Interactive grid menu
I have followed this link to hide most of the options from the interactive grid.
Remove Oracle Apex Interactive Grid row actions
but I am not able to hide "Fill", "Clear" and "...
- 347