Hi. Anyone got any good examples of password protecting a file using PL/SQL. More specifically password protecting a ZIP file. We make use of both APEX_ZIP and Anton Schiffers AS_ZIP ( I did find a forum post, but it doesnt seem to be encrypting the files when I add them. (
12-Dec-2018 09:50:AM by: shaun.mauer
hi all
11-Dec-2018 08:47:PM by: Vinayak
Thank you very much guys! It’s always a pleasure :slightly_smiling_face:
11-Dec-2018 01:20:PM by: maxime_tremblay
Hi all, I have created a Bar chart in Oracle APEX. In Y-axis it is automatically getting sorted alphabetically, even I have used Order by clause. How can I off this automatic sorting. Thank you.
11-Dec-2018 12:53:PM by: Saurabh Sagar Sinha
Seconded! thanks @maxime_tremblay. You are setting an awesome example!
11-Dec-2018 10:03:AM by: Sullivan
Hello everyone. this morning I woke up with the desire to say thank you to @maxime_tremblay for the person he is. indeed, he is always there to help people to move forward he is reactive and thanks again for that.
11-Dec-2018 09:24:AM by: Souleman
You can use javascript:apex.navigation.openInNewWindow() and construct the APEX URL that way.
11-Dec-2018 09:19:AM by: Ross Henderson
Hi All, I have a modal dialog in my application. On click of a button opens this modal dialog which has a classic report in it. This Classic report contains a Link column. Onclick of this link the control closes the modal dialog and navigates to the target link in the parent. My requirement is to open the link of the Classic report in a New tab instead of navigating it to a parent page. When I use in my link it open a blank window in new tab. How can I fix this? Thanks in advance.
11-Dec-2018 09:16:AM by: Prashanth
@shaun.mauer - not that I am aware. I am working on a project now where we would like to do that with 20+ applications. The best we've come to making it happen is to attempt to put what we can into stored procedures/packages and then call that from all of the page zeros. Even though we have multiple page zeros, we have one place to maintain the code.
10-Dec-2018 03:37:PM by: Shane Bentz
@Dominique Denie how about: SELECT APEX_ITEM.SELECT_LIST_FROM_QUERY(3,job,<your function call returning query as varchar2 string text>)job FROM emp
10-Dec-2018 12:11:PM by: Sullivan
Is it possible to have a common page 0 across multiple applications in the same workspace? So have it defined in a "master" application and then all other applications "inherit" that page 0, like we can do with themes and plugins?
10-Dec-2018 11:27:AM by: shaun.mauer
What plugin exactly are you using? I’ve seen some that were able to use a callback function instead of having everything in the title attribute
09-Dec-2018 03:12:PM by: maxime_tremblay
@Souleman Actually, I am not posting a big clob, the return string is of approx. 4200 characters, just a bit above limit. I am having a simple HTML table, summary of some form items and their values
09-Dec-2018 03:38:AM by: eureka7
Hi. for me, posting a clob in a tooltip is not a good approach. Now if you have to do it like that, you could only get the first 4000 characters using SUBSTR.
08-Dec-2018 01:02:PM by: Souleman
Hi All, I am using APEX Tooltip Plugin Item and I have more than 4000 characters in the text to display inside tooltip (which is returned by a function). It's displayed on classic report column. I am getting `buffer too small error`. If I declare as CLOB then I get `inconsistent data type`. ```select task_processed_by ,task_processed_on ,'<span class="req-overview" title="'||get_request_overview(case_id)||'"> <a href="#">'||regexp_replace(comments,'<p>|</p>')||'</a> </span>' as text ,case_id from wf_processing_record``` what to do?
07-Dec-2018 10:15:PM by: eureka7
07-Dec-2018 05:02:PM by: Gcon
07-Dec-2018 12:47:PM by: Souleman
Thanks, I was able to achieve it using JS functions.
07-Dec-2018 12:46:PM by: Prashanth
do not reinvent the wheel. :sweat_smile:. but you can use javascript functions. setTimeout () and clearTimeout (). To hide the success region after milliseconds
07-Dec-2018 12:38:PM by: Souleman
Is there any custom code if I don't want to use a plugin?
07-Dec-2018 12:09:PM by: Prashanth
you can go to there are excellent plug-ins that do that. ;)
07-Dec-2018 11:50:AM by: Souleman
Hi All, Is there a way to Fade Out success message after a few seconds? Currently, user needs to manually close it every time. I am currently on APEX 18.2. Thanks in advance
07-Dec-2018 11:46:AM by: Prashanth
Hey guys. I've been looking up how the login process works and I haven't been able to figure out this question: On login can you pass a value to an item id on the home page?
07-Dec-2018 09:24:AM by: Ross Henderson
on the parent page create a dynamic action and set 'When' attribute on 'Dialog Closed'
07-Dec-2018 07:21:AM by: wojciechsowa
No, how
07-Dec-2018 07:18:AM by: Gcon
Hello! Did you try 'Dialog Closed' dynamic action?
07-Dec-2018 07:14:AM by: wojciechsowa
Hi. I am facing this issue after upgrading application from apex 4.2 to apex 18.2. When i navigate between pages source code is showing up. I have set enabled in frames to allow also. can anybody let me know how to fix this
07-Dec-2018 06:30:AM by: pritham9
okay thanks for confirmation:blush: @maxime_tremblay
07-Dec-2018 05:17:AM by: Ketan
Thanks kiran
07-Dec-2018 03:55:AM by: anjlesh8
You may get these msgs to spam folder.. please check @anjlesh8
06-Dec-2018 09:45:PM by: Kiran D
Hi, how can I refresh parent page by closing modal dialog? I use Apex 5.1.4
06-Dec-2018 08:01:PM by: Gcon
Ok. I will try out. Thanks
06-Dec-2018 03:12:PM by: Prashanth
Thanks Maxime
06-Dec-2018 02:44:PM by: anjlesh8
I'm afraid this has nothing to do with APEX as it's a browser feature/behaviour
06-Dec-2018 01:23:PM by: maxime_tremblay
you can change it at the application level using shared components -> application definition attributes in the properties section: Application Email From Address ```Determines the email address to use as the from address in the application. This from email address is used when sending email from interactive report email download and subscription in the application. This value can be a literal string containing a valid email or a static substitution reference defined in the application using substitution syntax. Oracle does not recommend using an item substitution at the application or page level since it only works for email downloads, but not in a subscriptions. Examples: &MY_APP_EMAIL_FROM.```
06-Dec-2018 01:17:PM by: maxime_tremblay
Sounds like you'll have to add some javascript event listening for that. You can use static id, onmouseover event, and apex.navigation.dialog api to call a modal page.
06-Dec-2018 01:06:PM by: Ross Henderson
Hi , how Can i change from email address in mail send interactive report download feature . by default its showing from email address is "".
06-Dec-2018 10:19:AM by: anjlesh8
Hover text shows only label name
06-Dec-2018 07:34:AM by: Prashanth
Hi my application i am doing login with encrypted(using JS) password field and in plsql authentication process matching the value with stored encrypted password value. while saving password in chrome it is saving as plain text and in firefox,safari it is saving as a encrypted text(check image). So the issue is when i try to login in firefox and safari using saved password it would not allow to login. i am not sure whether it is browser's issue or apex's password item. Any help appreciated.
06-Dec-2018 07:34:AM by: Ketan
Hi APEXPERTS, I have a requirement to show item help text on hover of the question mark icon. Currently, it only displays the Item Lable on hover. How can I display the full help text on hover of the question mark icon? Thanks,
06-Dec-2018 07:33:AM by: Prashanth
Hi All. Can we create table dynamically from oracle apex application without sql workshop. How the project is laid out is user should have capability to create table from UI. Tried Quick sql but that doesn’t work for this requirement
05-Dec-2018 10:07:PM by: pritham9
if you want you can wrap it in an application LOV using your function you’ll then be able to use it in multiple places
05-Dec-2018 12:44:PM by: maxime_tremblay

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
Muhammad Azee
12-Dec-2018 09:31
Quick Question for Oracle Set define off query
0 replies
12-Dec-2018 07:26
How to capture the new Primary Keys when adding rows to an IG
1 replies - last reply: 12-Dec-2018 09:22- by: Niels IH
Balaji Madhav
12-Dec-2018 06:31
Oracle Apex Data Load Table Transformation Rule
5 replies - last reply: 12-Dec-2018 09:06- by: Scott Wesley
12-Dec-2018 05:28
ords in aws
1 replies - last reply: 12-Dec-2018 05:32- by: Billy~Verreynne
12-Dec-2018 04:24
How to create Apex User With App Custom Authentication
2 replies - last reply: 12-Dec-2018 07:28- by: M-Joveini
12-Dec-2018 03:03
Event triggering order
1 replies - last reply: 12-Dec-2018 05:48- by: Billy~Verreynne
Raymond A
12-Dec-2018 00:22
Session length still not greater than 12 hrs
0 replies
11-Dec-2018 21:23
APEX 5.1.2 button images display for some users, not all
1 replies - last reply: 12-Dec-2018 06:28- by: Billy~Verreynne
11-Dec-2018 21:14
Hidden column appears when setting editable Interactive Grid to read only - urgent solution needed
1 replies - last reply: 11-Dec-2018 21:14- by: melinda_f
11-Dec-2018 19:06
How to position a LOV next to Actions in IR
1 replies - last reply: 11-Dec-2018 19:06- by: Sgodavar-Oracle
11-Dec-2018 18:38
Refresh LOV in another region
1 replies - last reply: 12-Dec-2018 05:22- by: Franck N
11-Dec-2018 18:04
How to add multiple rows into an interactive report?
1 replies - last reply: 12-Dec-2018 05:35- by: Franck N
11-Dec-2018 17:57
Client Certificate Authentication - Apex_Web_Service
1 replies - last reply: 12-Dec-2018 06:33- by: Billy~Verreynne
11-Dec-2018 17:14
Apex 18.2 IG Select List Problem
0 replies
11-Dec-2018 17:00
setFocus to Column in IG on Tab After a Calculation
0 replies
11-Dec-2018 16:22
Bug in interactive report option's to save an additional report?
0 replies
11-Dec-2018 15:41
Added row in IG not visible after Save
2 replies - last reply: 11-Dec-2018 16:26- by: InoL
11-Dec-2018 15:31
Oracle RAD stack REST, APEX and Database
0 replies
11-Dec-2018 15:04
Shuttle value as 'in' filter on drilldown Interactive Report
5 replies - last reply: 11-Dec-2018 17:38- by: Keegan_W
Niels IH
11-Dec-2018 13:03
IG Context menu disappears after add row action
1 replies - last reply: 11-Dec-2018 18:31- by: John Snyders-Oracle
10-Dec-2018 15:45
IG_Cookbook_18.2_rev4_f101 checkbox
3 replies - last reply: 12-Dec-2018 02:28- by: John Snyders-Oracle
07-Dec-2018 21:22
Oracle APEX 18.2 with Oracle XE 18 - Low performance
8 replies - last reply: 12-Dec-2018 06:14- by: Billy~Verreynne
07-Dec-2018 17:55
Mobile App with APEX
10 replies - last reply: 12-Dec-2018 08:48- by: Eslam_Elbyaly
Soukaina IDRI
10-Nov-2018 19:59
How to create dynamic overview of customer 360 degree
8 replies - last reply: 11-Dec-2018 15:57- by: Soukaina IDRISSI
Soukaina IDRI
30-Oct-2018 08:45
How to open page of application directly from external link
3 replies - last reply: 11-Dec-2018 16:44- by: Soukaina IDRISSI


Peter Raganitsch  
APEX upgrade in 3 minutes
12-Dec-2018 10:25:41 by: Juergen Schuster
Adrian Png  Other
Video: Blockchain in APEX
Blockchain, Videos
12-Dec-2018 10:21:27 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: Massachusetts, Boston, permanent
11-Dec-2018 19:14:56 by: Juergen Schuster
Kevin Rutten    
New Plug-in: PDF from SQL Query
11-Dec-2018 08:57:05 by: Juergen Schuster
Simon Boorsma    
New Plug-in: Oracle Digital Assistant Chat Box
10-Dec-2018 18:06:51 by: Juergen Schuster
Marko Gorički  
Bug with duplicating radio groups
10-Dec-2018 12:21:18 by: Juergen Schuster
Denis Savenko  
Installation Guide P2
09-Dec-2018 17:36:43 by: Juergen Schuster
Francis Mignault  
Forms Modernization
Forms (Oracle Forms)
07-Dec-2018 18:08:18 by: Juergen Schuster
Learco Brizzi    Other
New Conference: APEX World 10th jubilee, March 25,26th, Rotterdam, Netherlands
07-Dec-2018 13:15:33 by: Juergen Schuster
Niels de Bruijn  
Single Sing On for APEX
07-Dec-2018 06:16:18 by: Juergen Schuster
Souleman DEMBELE    
New Plug-in: Get plain numbers out of formated numbers
05-Dec-2018 21:14:58 by: Juergen Schuster
Adrian Png    
Low Code Development Systems
05-Dec-2018 21:11:39 by: Juergen Schuster
Jackie Mcilroy    Other
Newsletter #30 is out!
Newsletter, Press,
05-Dec-2018 17:26:19 by: Jackie Mcilroy
Jackie Mcilroy    Other
New Podcast: Never Apologize! #LowHighPodcast
Podcast, Press,
05-Dec-2018 15:17:56 by: Jackie Mcilroy
John Snyders  
Thoughts on Progressive Web Apps (PWA)
Progressive Web Applications
05-Dec-2018 03:42:12 by: Jackie Mcilroy
Sam Khalaf  
Integration with AWS Simple Email Service
05-Dec-2018 03:37:37 by: Jackie Mcilroy
Lucas Rayner  
Show Alerts with Dynamic Actions
Dynamic Actions
04-Dec-2018 09:35:42 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: Florida, Orlando, contract, on-site
03-Dec-2018 18:25:32 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: California, San Francisco, contract, on-site
03-Dec-2018 18:24:09 by: Juergen Schuster
Ronny Weiß    Other
Member of the Month November: Consistent delivery of high quality Plug-ins
Member of the Month
01-Dec-2018 12:42:59 by: Juergen Schuster
Oleksii Vykhrystiuk    Other
Internet Use Case with APEX
Applications, Internet
01-Dec-2018 12:22:06 by: Juergen Schuster
Matt Mulvaney    
Application Archives
Installation, Versioning
30-Nov-2018 20:46:40 by: Juergen Schuster
mike hichwa    Other
What do you use APEX for?
30-Nov-2018 20:43:09 by: Juergen Schuster
Vincent Morneau  Other
Video: Progressive Web Apps (PWA)
Mobile, Videos
29-Nov-2018 23:15:00 by: Juergen Schuster
Joel Kallman    Other
29-Nov-2018 16:15:35 by: Juergen Schuster
Jackie Mcilroy    Other
Video: Dynamic Actions for Beginners
Dynamic Actions, Videos
29-Nov-2018 15:50:45 by: Juergen Schuster
Adrian Png  
Quick Environment Setup with Lora
29-Nov-2018 11:04:45 by: Jackie Mcilroy
Ronny Weiß    
New Plug-in: QR-Code Scanner
28-Nov-2018 23:44:43 by: Juergen Schuster
Juergen Schuster    Other
Recorded beginners training 5.1 in Hindi
28-Nov-2018 11:13:39 by: Juergen Schuster
Ezequiel Portela    
New Plug-in: Number Fields
27-Nov-2018 01:50:55 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: Malaysia, Kuala Lumpurm, permanent, onsite, working visa
22-Nov-2018 23:01:42 by: Juergen Schuster
Ezequiel Portela    
New Plug-in: Embed an external Website
22-Nov-2018 22:58:42 by: Juergen Schuster

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20