All Questions
Tagged with oracle oracle-apex
3,550
questions
0
votes
1
answer
28
views
Redirect to another page after downloading PDF file from REST api in Oracle Apex
I have an interactive report, in which a column is clicked and then a PDF file downloaded by calling a REST API. This column is a link to another page where Before page header process runs and ...
0
votes
1
answer
42
views
Oracle Apex tree child node returning multiple times
I have an apex tree with 3 layers: (Apex version 22.1)
BU_NAME
ORG_UNIT_NAME
DEPT_NAME
Source Table:
DEPT_BU_LIST
DEPT_ID BU_NAME ORG_UNIT_NAME DEPT_NAME
1 A_BU AX_ORG A1_DEPT
2 ...
0
votes
1
answer
33
views
Oracle Apex REST response - PDF File not returning correctly
I have an REST API which take a PDF form and the data to fill this pdf form with. In response, pdf form with filled data is returned.
I have tested this API in Postman, work fine.
Now I am making a ...
2
votes
1
answer
62
views
Loading CSV files with double quotes in field values via Oracle Loader External table
Requesting your help and expertise on the below:
Oracle DB 19c on UNIX server
Requirement:
CSV files come in on a daily basis in a Unix directory (where the database resides) and gets loaded to a ...
-1
votes
1
answer
50
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 ...
0
votes
1
answer
40
views
Error while downloading a file in Oracle APEX
For my application, I wanted to implement the Upload and Download feature, so I have implemented the upload feature. The uploaded document (pdf) should be visible on the user's task details page. I ...
0
votes
1
answer
50
views
ORA-20999: Failed to parse SQL query! ORA-06550: line 4, column 82: ORA-00936: missing expression
While trying to build a prompt context in Oracle APEX, I can't tell what's wrong with my code below:
SELECT
'Overview of the product : '|| PRODUCT_DETAILS ||BLOB || BLOB||
'This product cost ...
0
votes
0
answers
35
views
Oracle APEX - Export to excel - top alignment
I'm currently working with Oracle APEX version 23.2.5 and I'm looking to customize the way data is exported to Excel. Specifically, I need to set the cell alignment to "top" globally for all ...
0
votes
0
answers
30
views
How can I update QTY value in an ITEM_MASTER table based on more than QTY value in STK_TRANS_DETAILS table based on some conditions?
I have two tables ITEMS_MASTER this table include my (ITEM_CODE, ITEM_NAME,ITEM_QTY ,...) And the other table is called STK_TRANS_DETAILS I insert the items(ITEM_CODE,QTY,PRICE,ITEM_NAME,..) in it ...
0
votes
1
answer
44
views
How can i implement a auto Increment pk in a interative grid
I tried to implement an auto increment on my default interactive grid page by following several tutorials on YouTube, but each tutorial taught differently and none solved my problem,
the new line is ...
0
votes
1
answer
33
views
How to handle Oracle timestamp decimal separator
I have an external Oracle database. I'm trying to export table into Oracle APEX database. The problem is that the timestamp format from external database is like this 21/01/17 23:34:50,000000000 (note ...
0
votes
1
answer
43
views
apex_page.get_url pass item value which have colon(:) delimited list
I use apex_page.get_url to prepare url in sql query in that way:
'javascript:window.open("'||apex_page.get_url(p_page=>'9', p_items=>'P9_A,P9_B,P9_C,P9_D,P9_E',
p_values=> Z.COLUMN_VAL||...
0
votes
1
answer
133
views
Oracle APEX - ORDS_PUBLIC_USER is a common user [...] require CDB$ROOT connection
Let's say first that i'm a noob with server and i jumped to linux world only an year ago...
I'm trying to set up my Oracle APEX installation on Oracle Linux 9 (in a VM) for develop a custom software ...
0
votes
1
answer
61
views
Referencing APEX_230200 view/table from another schema
I am using Oracle Autonomous Database on OCI. I want to create a foreign key in one of my schemas that references a view in APEX_230200 schema. I executed the statement below using ADMIN user (which ...
0
votes
0
answers
19
views
Export xlsx format from IR for date columns
I want to export from my IR in xlsx format but there's something different about displaying date columns in excel and IR.
I've set this code in Database Session to show all dates in APEX application ...