Questions tagged [oracle-apex]
Oracle Application Express (Oracle APEX) is a rapid Web application development tool that lets you share data and create applications. Using only a Web browser and limited programming experience, you can develop and deploy applications that are fast and secure.
oracle-apex
6,986
questions
0
votes
0
answers
22
views
Session persistence in oracle apex
in oracle apex, how to implement auto-login in a new window:
When a user logs in, store their APEX_SESSION_ID securely (e.g., in a browser cookie or local storage).
When opening a new window, ...
1
vote
0
answers
11
views
Apex pretius nested reports plugin is not able to install
I downloaded the Apex pretius plug for nested reports in Apex 22.1, but it throws this error when I try to install the zip.
**Unable to find file.install.sql**
https://github.com/Pretius/apex-nested-...
- 465
0
votes
0
answers
27
views
connect apex with mysql on oci
I have mysql database located on oci with apex server located on oci too.
I tried to connect apex with my database to create interactive report using rest enabled sql service. I create private ...
0
votes
2
answers
23
views
Read only columns in Interactive grid in Apex
I have an interactive grid report in Apex, I want to make only two columns as editable and rest all of them as read only. I have tried setting non-editable columns as display only but still I am able ...
- 150
0
votes
1
answer
20
views
I'm getting No data found error when clicking on ID and editing the FORM in Oracle Apex
I try to change the server side condition of the process like process works only if ID is not null, but its not working.
also tried to change process type but it wasn't working.
...
-1
votes
0
answers
17
views
Add button for each child node
I have a tree region and for each last child node i need to add a button.
So for the last node the button should show and when i click it calls a package to execute some scripts corresponding to the ...
- 465
-1
votes
0
answers
24
views
Oracle Apex 22.1 Unable to save tree [closed]
I have written query for tree region. I cannot share it due to data constraints.
However the issue is the query for tree gets validated. But when i click on save it says fix errors before proceeding. ...
- 465
0
votes
1
answer
22
views
How to prevent user select start date bigger than end date in date picker calender?
I have 2 date picker calendar start date and end date
How can I check and compare when the user select end date must be bigger than start date in oracle apex ?
How to use validation and prevent user ...
- 782
0
votes
0
answers
21
views
Oracle Apex Tree like structure with Button only for child node
I want to create a tree like structure where there are BUs .. Inside BU there are departments and inside departments there are Employees. Inside employee there is Performance Q1, Performance Q2 etc.
...
- 465
0
votes
1
answer
22
views
authorization scheme on page item in oracle apex
I am trying to authorize page item in apex through authorisation_schema, for this i have created authentication user control in cloud and created authorise schema for that authentication return value ...
- 15
0
votes
0
answers
16
views
Oracle Apex Filter Option Under the Actions Menu for an Interactive Report
I apologize in advance if this question is vague or confusing.
In Oracle Apex for the Filter options under the Actions menu for an Interactive Report for a date column, is there a way to change the ...
- 1
0
votes
2
answers
30
views
Checkbox group filter how to put it in where clause
I have a interactive report with some items that are used as a filter in this report, like text field, select list etc.
Now i have a checkbox group but I don't know how to put the input in the where ...
- 136
0
votes
0
answers
18
views
Unable to Type anything in sql developer web not even apex sql command window
I am unable to type anything in sql developer web from oracle cloud console not even apex sql command window in oracle apex, the erorr is
Oracle Apex Cloud sql command window:
{ "code": &...
- 1
1
vote
1
answer
46
views
Invoke automatic row processing (DML) process programmatically
I am using Oracle APEX 22.1.4 and I am trying to invoke automatic row processing (DML) process programmatically.
I tried as follows but it doesn't work.
apex.server.process(
'SAVE_PERSON', // ...
- 609
-1
votes
1
answer
49
views
Converting multiple columns into rows [duplicate]
I have an input table in Oracle like this. How do i get an output by converting the columns (year number) and corresponding values into rows
INPUT_TABLE
KEY_ID YR1 YR2 ...
- 1