Slack

You will need to use a REST service to do it. It's normally really quite easy to do.
21-Jan-2019 09:29:AM by: Ross Henderson
Hi ,bug in apex18.2 : when i use popup lov colums in interactive grid for label in chart show me this error 'no_data_found'
20-Jan-2019 09:28:PM by: meysam
:joy:
19-Jan-2019 02:58:PM by: Nadine Bri
2 hours lifetime wasted for a non-existent option :ballot_box_with_check:
19-Jan-2019 02:57:PM by: Nadine Bri
Must be an error :sweat_smile:
19-Jan-2019 02:53:PM by: maxime_tremblay
:see_no_evil:
19-Jan-2019 02:53:PM by: maxime_tremblay
I checked again. It's really there in the documentation, see screenshot. Here the URL: https://docs.oracle.com/en/database/oracle/application-express/18.2/htmig/upgrading-from-previous-Oracle-application-express-release.html#GUID-0E9AC015-883E-406C-96C5-FCAB7CD54CD1
19-Jan-2019 02:11:PM by: Nadine Bri
Ah, OK, thanks. I read in the documentation somewhere that I should have 18.2 in the selection. Therefore I thought that something went wrong...
19-Jan-2019 02:05:PM by: Nadine Bri
5.1/18.1 is the latest so you should go with that one
19-Jan-2019 02:04:PM by: maxime_tremblay
I did some time ago and it’s working :wink:
19-Jan-2019 02:00:PM by: maxime_tremblay
Hi all, I upgraded APEX to 18.2. However, in the app settings compatibility mode, I cannot set the compatibility mode to the current version. There is no 18.2 or 'current version' entry in this dropdown field. Maximum is 5.1 / 18.1. According to documentation, there should be an entry for current version. I already searched the instance settings for a global option which prevents me from doing this, and I also upgraded all offered application items in the app utilities, but without result. Any ideas on this?
19-Jan-2019 10:35:AM by: Nadine Bri
Thanks Maxime! I read this and it sounds like a solution. However, I did not try it out yet.
19-Jan-2019 10:29:AM by: Nadine Bri
Hi, Does anyone have experience sending SMS using APEX application?
18-Jan-2019 09:54:PM by: Didou
Hello !! How create the page of reset password on apex5 ??
18-Jan-2019 11:23:AM by: ERICKP
I don't think there is a way to get the MAC-address. You can run this in the SQL Command window, to see what kind of CGI information you might get. begin owa_util.print_cgi_env(); end;
18-Jan-2019 11:16:AM by: svenweller
Good idea! The log seems to have the info, but it is dificult to distinguish between the various developers. Apex_application_pages is also promising. But it seems empty when looking at it from inside an app. I could grant access to the base tables, but that option limits its usefullness to environments where we can set such a thing up. Also there is the cookie ORA_WWV_REMEMBER_UN which often has the info I want.
18-Jan-2019 11:03:AM by: svenweller
Hello all. if i have multiple Interactive Reports on one page and I need to have an export to CSV button for each of them instead of using the download option under actions. I know I can use this link f?p=&APP_ID.:&APP_PAGE_ID.:&SESSION.:CSV: if I have one report on a page. Does anyone know how I can modify this link to work on multiple IR's on one page, each having its own Export to CSV button? thank you!
17-Jan-2019 09:15:PM by: abul_feed
you could try to query apex_workspace_activity_log
17-Jan-2019 07:02:PM by: peterraganitsch
My default solution for this problem is to use two items. One to display which is not stored and one hidden to store.
17-Jan-2019 06:21:PM by: svenweller
From inside an apex app, is there a way to find out which developer is currently logged on/working? Like the APP_USER of the page designer app itself.
17-Jan-2019 06:13:PM by: svenweller
Colleague got it working, I made a mistake (y)
17-Jan-2019 10:54:AM by: Ross Henderson
It doesn't seem unfortunately. I forgot to mention that the key is generated on page load by returning a random 16 digit string via a function. So if I call it again by the computation it will return a new key, not the one that's displayed.
17-Jan-2019 10:16:AM by: Ross Henderson
Thanks Maxime, I'll give it a go today!
17-Jan-2019 08:47:AM by: Ross Henderson
the trick is to set the display item's save session state attribute to no then you will still have the DA populate the displayed value on page submit you will need to have an after submit computation that will set the corresponding value using the same process used to display the value
16-Jan-2019 04:39:PM by: maxime_tremblay
Hey guys, stupid question. I'm trying to generate a key that gets insert into a display only page item, because I don't want the user to be able to edit it. I then I want to use this value to insert into a table via an ARP. But if I insert it using a DA it breaks the session state, and if I use a page load procedure it keeps overwriting it with null. Read Only text-fields also don't work. What silly thing am I doing wrong?
16-Jan-2019 04:33:PM by: Ross Henderson
there’s the article I mentioned https://apex.oracle.com/pls/apex/germancommunities/apexcommunity/tipp/6401/index-en.html hope this helps
16-Jan-2019 04:08:PM by: maxime_tremblay
I'll keep that in mind. Luckily, with a closer look at the documentation, I found my error in passing a URL parameter to the web service. Thanks for the help though!
15-Jan-2019 07:39:PM by: jhaut
When I did this I used prepare_url to pass ALL the items back in.
15-Jan-2019 03:13:PM by: Ross Henderson
You should be able to integrate a jquery plugin easily in your app Or even better create a plugin for it
14-Jan-2019 10:28:PM by: maxime_tremblay
Do you have the ORDS debugging option enable and printing to the page? This might also be able to help you https://www.thatjeffsmith.com/archive/2018/10/preventing-500-status-codes-with-oracle-rest-data-services/
14-Jan-2019 10:27:PM by: maxime_tremblay
There is a way to do it but it requires some work You will need to change some attributes of the CKEditor regarding the file manager you will also need to create an APEX page that will handle the file upload and select And on top of that you will need to have a rest service that will handle the file downloading There was an article about how to do all of that
14-Jan-2019 10:23:PM by: maxime_tremblay
Hi experts, I have in my application, a page that is based on form, and i have another page that is a modal tree that open when click on button in the form. When we select the node from tree page, we pass between the modal page to the form page, with apex_util.prepare_url , the selected node id. My issue is when we fill the form and when we set the page items manually, and after we send back the select node id, the data on items that we filled disappear. And the only page items that are on the form, is the selected node id. I understand it happened cause the apex_util.prepare_url and the only item we send to the page based form(selected node id). APEX_UTIL.PREPARE_URL('f?p=' || :APP_ID || ':10:'|| :APP_SESSION ||'::NO::P10_ITEM:ABC as link In the form items there is 10+ items, how can i avoid to use a "dummy" hidden items for each item in the form. Please correct me if im wrong and if its possible to keep on session the items, that when we sent back the selected node id, we will not loosing data on items. Thanks.
14-Jan-2019 08:49:PM by: Lior
I've not had the change the template. From my (limited) understanding, the temp table creates and sorts it into the correct order, including children
14-Jan-2019 01:47:PM by: Ross Henderson
@Ross Henderson Does that method bypass having to change the template?
14-Jan-2019 12:58:PM by: shaun.mauer
I don’t know - haven’t checked it recently
14-Jan-2019 12:37:PM by: roelhartman
I.e: with TBL_TEMP_HIERARCHY as ( select MENU_ID, level as "MENU_LEVEL", MENU_NAME, LINK_TARGET, null as "IS_CURRENT", MENU_IMAGE, null as "IMAGE_ATTRIBUTE", null as "ALT_ATTRIBUTE" from TBL_NAV_MENU start with PARENT_ID = 99999999998 connect by prior MENU_ID = PARENT_ID order siblings by MENU_NAME asc ) select MENU_LEVEL as "LEVEL", MENU_NAME as "LABEL", LINK_TARGET as "TARGET", IS_CURRENT as "IS_CURRENT_LIST_ENTRY", MENU_IMAGE as "IMAGE", IMAGE_ATTRIBUTE as "IMAGE_ATTRIBUTE", ALT_ATTRIBUTE as "IMAGE_ALT_ATTRIBUTE" from TBL_TEMP_HIERARCHY
14-Jan-2019 10:57:AM by: Ross Henderson
The way I got around this issue was to create a temp table which created the navigation list as a tree, and then selected from that. You have to create a level 0
14-Jan-2019 10:57:AM by: Ross Henderson

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
3383820
21-Jan-2019 11:22
Unable to see data in chart upon click back button
Link
0 replies
3641416
21-Jan-2019 08:57
Oracle apex 18 calling interactive grid inside modal dialog
Link
0 replies
Fabrizio Dell
21-Jan-2019 07:52
hot to loop through interactive grid a make custom update
Link
1 replies - last reply: 21-Jan-2019 10:00- by: Franck N
Eslam_Elbyaly
20-Jan-2019 18:26
Hosting an apex based website
Link
4 replies - last reply: 21-Jan-2019 13:09- by: Eslam_Elbyaly
user8864168
20-Jan-2019 16:16
How to archive your Oracle Application Express applications into tables within your Database Cloud S
Link
0 replies
ebenwalker
20-Jan-2019 16:16
Tab Key control on an Interactive Grid
Link
0 replies
3834893
20-Jan-2019 14:52
Data Loading in APEX issue
Link
1 replies - last reply: 20-Jan-2019 15:37- by: fac586
Arun2912
20-Jan-2019 11:31
Adding logo as a separate layer in oracle apex 18.2
Link
4 replies - last reply: 21-Jan-2019 09:42- by: Arun2912
gharbeya
20-Jan-2019 08:06
create 2 static content regions based on 2 different table
Link
1 replies - last reply: 20-Jan-2019 11:10- by: fac586
Maahjoor
20-Jan-2019 04:28
Recommeded production environment for apex
Link
0 replies
Kariman
20-Jan-2019 00:13
hide tab in selector display when region no data found
Link
4 replies - last reply: 21-Jan-2019 08:26- by: Franck N
Kariman
19-Jan-2019 13:30
client side condition javascript expression
Link
4 replies - last reply: 21-Jan-2019 05:10- by: Kariman
Carlos Privat
18-Jan-2019 23:36
Apex 18.2 Interactive Report don´t show chart when application use pt-BR language
Link
0 replies
Jorgelina
18-Jan-2019 19:44
Apex5.1 - Side Navigation Menu - entry with word wrap
Link
3 replies - last reply: 21-Jan-2019 10:59- by: Franck N
Ananda Basak
18-Jan-2019 19:40
How to set value of a page item on Mouse enter on a report column
Link
5 replies - last reply: 20-Jan-2019 20:20- by: Ananda Basak
Richie V
18-Jan-2019 16:13
Font Awesome list entry not showing image
Link
1 replies - last reply: 18-Jan-2019 19:45- by: fac586
Lauricio
18-Jan-2019 11:29
APEX 5.1 send mail
Link
2 replies - last reply: 18-Jan-2019 19:25- by: Richie V
AmitK05
18-Jan-2019 07:58
How to Pass Java script Array of selected records from grid in PL/SQL procedure in APEX
Link
3 replies - last reply: 18-Jan-2019 19:24- by: Jorgelina
NelsonMendes
17-Jan-2019 20:32
How to create a validation between 2 date picker fields :PA cannot be > then :PB
Link
7 replies - last reply: 19-Jan-2019 09:26- by: Franck N
KishoreChennu
16-Jan-2019 06:01
Is there a way to monitor the SQL queries fired using SQL workshop?
Link
7 replies - last reply: 21-Jan-2019 12:54- by: AndrewSayer
Omar Baig
15-Jan-2019 12:27
Prevent same record in Interactive Grid in Oracle Apex 18.1
Link
7 replies - last reply: 21-Jan-2019 11:40- by: Jorgelina
AhmedHelmy
14-Jan-2019 13:36
Pie Chart Title
Link
2 replies - last reply: 20-Jan-2019 21:47- by: AhmedHelmy
Laury
11-Jan-2019 10:57
Display a BLOB in an Interctive Grid Report
Link
15 replies - last reply: 20-Jan-2019 22:54- by: fac586
Eslam_Elbyaly
09-Dec-2018 10:09
Master-Detail between a form on a table and an interactive grid
Link
11 replies - last reply: 19-Jan-2019 17:24- by: Eslam_Elbyaly
BijuRajan6343
18-Sep-2018 14:34
How can i send SMS from oracle database using plsql function
Link
20 replies - last reply: 21-Jan-2019 10:49- by: Pavel_p

News

X
    
 
ImageNewsFavoriteForward
Jackie Mcilroy    Other
First Live #LowHighPodcast: Feb. 6th, 12pm ET, join and participate
Podcast
Link
17-Jan-2019 19:32:49 by: Juergen Schuster
Dimitri Gielis  Other
Advantages and Disadvantages of APEX new release system
APEX 18, Installation
Link
21-Jan-2019 15:14:17 by: Jackie Mcilroy
Tobias Arnhold  Other
APEX Competition 2019
Press
Link
21-Jan-2019 14:59:05 by: Jackie Mcilroy
morteza mashhadi  
intro.js quick help
Help
Link
19-Jan-2019 12:08:08 by: Juergen Schuster
Carsten Czarski  
Interactive Grid on Web Source Modules Part 2
Interactive Grid, REST
Link
18-Jan-2019 20:15:39 by: Juergen Schuster
Niels de Bruijn  
New Kerberos SSO version
Authentication, SSO
Link
18-Jan-2019 16:19:06 by: Juergen Schuster
morteza mashhadi  
Alternative Reporting in Stimulsoft
Charts, Reports
Link
18-Jan-2019 06:53:37 by: Juergen Schuster
Carsten Czarski    Other
Office Hours: Fuzzy Search, Jan, 24th
Webinar
Link
17-Jan-2019 19:58:11 by: Juergen Schuster
Scott Wesley  
Switch authentication schemes at runtime
APEX 18, Authentication
Link
17-Jan-2019 17:55:35 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: USA, Salt Lake City, permanent, on site
Jobs
Link
17-Jan-2019 15:56:45 by: Juergen Schuster
Scott Wesley  
Social Sign-in Authentication
Authentication, SSO
Link
17-Jan-2019 03:40:09 by: Jackie Mcilroy
Scott Wesley  
Application Session Sharing
APEX 18, Authentication
Link
17-Jan-2019 03:35:48 by: Jackie Mcilroy
Juergen Schuster  Other
New Job Offer: Germany, Munich, permanent, Working Visa
Jobs
Link
15-Jan-2019 20:38:50 by: Juergen Schuster
Juergen Schuster    Other
New Slack Channel: #aop for the free unsupported cloud tier, join
Slack
Link
14-Jan-2019 16:16:04 by: Juergen Schuster
Dimitri Gielis    Other
AOP 19.1 is out, Free to use Development Mode on Cloud
Printing
Link
14-Jan-2019 16:08:31 by: Juergen Schuster
Craig Sykes  
Use Oracle's Apiary to document your Webservice
REST
Link
14-Jan-2019 15:15:29 by: Juergen Schuster
Martin Nielsen  
Maximize JET Charts
JET
Link
13-Jan-2019 19:44:15 by: Juergen Schuster
Andrei Radzetski    
New Plug-in: Load Files from local file system directly to 3rd party cloud providers
File Upload, Plug-ins
Link
11-Jan-2019 18:03:42 by: Juergen Schuster
Patrick Wolf    Other
Video Office Hours: Page Designer
Page Designer, Videos
Link
11-Jan-2019 16:34:47 by: Juergen Schuster
APEXUTIL Wrocław  
Store Files outside the DB into public cloud
File Upload
Link
11-Jan-2019 15:50:03 by: Juergen Schuster
Connor McDonald  
ORDS 404 Error connecting to APEX
Error, ORDS
Link
11-Jan-2019 15:32:16 by: Juergen Schuster
Craig Sykes  
Creating an online leaderboard
Applications
Link
10-Jan-2019 19:58:16 by: Juergen Schuster
Patrick Wolf  Other
Webinar: Page Designer Deep Dive, Office Hours, January 10th
Webinar
Link
10-Jan-2019 03:14:08 by: Jackie Mcilroy
Joel Kallman    Other
New Podcast out: Joel Kallman, Make Oracle Cool Again ( MOCA )
Podcast
Link
09-Jan-2019 19:45:15 by: Juergen Schuster
Juergen Schuster    Other
Newsletter #31 is out!
Newsletter
Link
07-Jan-2019 15:40:08 by: Juergen Schuster
Jackie Mcilroy    Other
New Podcast: Don't Delete the Package! #LowHighPodcast
Podcast, Press, apex.world
Link
06-Jan-2019 17:52:19 by: Jackie Mcilroy
Alexis Galdamez    Other
New Video Training in Spanish
Trainings
Link
05-Jan-2019 00:31:05 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: Oracle, USA, San Francisco, permanent
Jobs
Link
04-Jan-2019 20:37:44 by: Juergen Schuster
Simon Boorsma    
New Plug-in: Post-it Stickers
Plug-ins
Link
03-Jan-2019 15:23:16 by: Juergen Schuster
Paul Jones  
Report Performance
Performance, Reports
Link
03-Jan-2019 04:25:53 by: Jackie Mcilroy
Juergen Schuster  Other
New Job Offer: UK, Linlithgow, permanent, onsite
Jobs
Link
02-Jan-2019 09:21:08 by: Juergen Schuster
Daniel Hochleitner    
New Plug-in: APEX Analytics
Plug-ins
Link
01-Jan-2019 17:17:13 by: Juergen Schuster

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20