7,170 questions
0
votes
0
answers
11
views
Oracle APEX reducing the size before inserting into Database table
Hi I am using APEX signature plugin https://apex.world/ords/f?p=100:710:3124430563211::::P710_PLG_ID:DE.DANIELH.APEXSIGNATURE and it works well.
It capture the signature and store in at APEX ...
- 1
0
votes
0
answers
8
views
Oracle Apex 24.2 SAML is missing
I have installed the latest version of Oracle Application Express ( APEX ), 24.2, and apply the patch available at the time to upgrade to 24.2.1. At the same time I have also upgraded ORDS to 24.4. My ...
- 8,538
1
vote
1
answer
23
views
Text field with Comma Separated values of one page not passing to model page text filed in Oracle apex 19.1
I am passing a text field value of one page to a model page, its passing but incomplete means string passing before comma.
Example: P1_SOURCE_FIELD value = "select ename,id,dept from emp",...
- 157
1
vote
1
answer
41
views
Classic Report with Dynamic SQL Statement Using Oracle Apex
I have a table with 2 columns, Query_Id and Sql_Stmt.
| Qry_Id | Sql_Stmt |
| -------| ---------------------------- |
| 1 | select empno,empname,sal from emp;|
| 2 ...
- 157
0
votes
0
answers
35
views
Remove default Content-Security-Policy in Oracle APEX
In Oracle APEX I have iframe, and I want to display a PDF file there. I'm following this tutorial. But I am getting this error:
Content-Security-Policy: The page’s settings blocked the loading of a ...
- 83
0
votes
0
answers
17
views
Oracle Apex IG row color change based on date
So I have an interactive grid which I would like to visualize the rows based on the value of a date column. What I would like it to behave:
If the date of that column is in the future AND it's at ...
0
votes
0
answers
33
views
How can I run jasper report automatically after save the order?
I have oracle APEX order program and I have order report using jasper report
Now I can print the order report when click on print button and this is the code I used in dynamic action and execute ...
- 1,033
1
vote
1
answer
127
views
Executing and retrieving stored procedure returns in python with oracle db
I am trying to run
plsql = """
DECLARE
l_zip BLOB;
BEGIN
l_zip := apex_export.zip( ...
- 612
0
votes
2
answers
40
views
How do I create and design a dashboard on Oracle Apex?
I'm not particularly savvy with Oracle Apex, and I was put in charge of the front-end development aspect. For the life of me, I can't figure out how to change these cards or even create a dashboard. ...
- 1
0
votes
0
answers
28
views
Consume External API In Oracle APEX?
Current Setup:
Database Server: Located in the Database Server Zone.
Application Server: Located in the Application Server Zone, running:
Oracle APEX 24.2
ORDS 23.xx
Tomcat
Problem:
We are ...
0
votes
0
answers
51
views
Change NLS_ session settings for Oracle REST service
Is their a way to set the NLA_LANG environment parameters within an anonymous PL/SQL code block being called via a REST endpoint in Oracle? Tried a number of the APEX_UTIL api's but nothing has worked,...
- 13
0
votes
0
answers
35
views
Oracle Forms POST-QUERY trigger in Oracle APEX
In Oracle Forms we have POST-QUERY trigger on a block, which sets the value of the global variable.
How to implement this in a best way in Oracle APEX? In APEX we are using IG for that.
We are using ...
0
votes
1
answer
34
views
Oracle APEX Interactive Grid with ordered rows
In Oracle APEX, I have a table that describes a one-to-many relation which is ordered with a column. So something like this:
create table T_MASTER (
MASTER_GUID RAW(16) DEFAULT ON NULL ...
0
votes
0
answers
18
views
Connecting Aws glue with oracle databank in apex
I am working in Aws . I have taken a source data in Aws glue from CDH through aws data CatLog and transformed and stored in S3 bucket inside Aws as the target. And from S3 with the help of crawler I ...
0
votes
1
answer
25
views
Disabling of APEX$ROW_SELECTOR based on a value in a column in the Interactive Grid
After searching through several blogs and solutions, I believe there is no existing solution for disabling the APEX$ROW_SELECTOR based on a value in a column in the Interactive Grid. Are there any ...
- 23