Has anyone ever encountered this issue: Funny characters (yellow highlight) inside apex builder preventing from saving changes. It occurred when copy/pasting a piece of code from another apex page. Now how to get rid of it?
21-Sep-2018 08:28:PM by: eureka7
21-Sep-2018 06:38:PM by: maxime_tremblay
That works nicely Maxime. Thank you very much
21-Sep-2018 06:36:PM by: kathrynbrooksgamble
here’s one way to workaround (there might be a better way to do) it’s based on the tooltip events you can remove the replace in your query and set this as you JavaScript Initialization Code: ```function( options ) { $( document.body ).on( "tooltipopen", function( event, ui ) { ui.tooltip.html(ui.tooltip.html().replace(/(\n)+/g, '<br>')) }); return options; }```
21-Sep-2018 06:26:PM by: maxime_tremblay
:disappointed: ah well, I thought I was missing something.
21-Sep-2018 06:08:PM by: kathrynbrooksgamble
you’re correct, I was testing on 5.1 18.1 is escaping HTML
21-Sep-2018 06:06:PM by: maxime_tremblay
using sql to get the tooltip as part of the region source (non computed) and specifying this column in the region attributes
21-Sep-2018 05:42:PM by: kathrynbrooksgamble
21-Sep-2018 05:41:PM by: kathrynbrooksgamble
What version are you on?
21-Sep-2018 05:41:PM by: maxime_tremblay
it seems to escape any html that I put in and cos its declarative I'm not sure how to stop that happening
21-Sep-2018 05:39:PM by: kathrynbrooksgamble
i tried that and it doesnt work.
21-Sep-2018 05:38:PM by: kathrynbrooksgamble
you’ll need to replace linebreaks with ‘<br>’
21-Sep-2018 05:28:PM by: maxime_tremblay
There shouldn’t be any problem I’ve seen it run on low end machine just fine are you using an apache server with ords?
21-Sep-2018 05:22:PM by: maxime_tremblay
what do I need to add to the text to get the break to render?
21-Sep-2018 05:21:PM by: kathrynbrooksgamble
in a tree using the tooltip attribute
21-Sep-2018 05:21:PM by: kathrynbrooksgamble
in an html tooltip using the title attribute?
21-Sep-2018 05:20:PM by: maxime_tremblay
Is there a way to get a line break into a tooltip ( on a tree - or other places in Apex).
21-Sep-2018 05:19:PM by: kathrynbrooksgamble
Hi all, Are there any problems with running APEX on Windows Server 2012 R12 and are these specs good enough to handle APEX? One of our clients has APEX installed with this setup but working in the APEX workspace is painfully slow. Thanks in advance.
21-Sep-2018 04:12:PM by: g0ldmagik
on a side note, you should obfuscate your passwords if this code is going to be used in production. Plenty of blogs available that explain how
21-Sep-2018 03:12:PM by: klostrie
Hi all, I have an issue saving a user in apex table in another workspace. In short and to make it simple: We have workspace WS1 and SCHEMA1 that contains Apex Application. We have also workspace WS2 and SCHEMA2 in same DB. We have users saved in Apex WS2 by calling a stored procedure SCHEMA2.create_user using `APEX_UTIL.CREATE_USER` api. We validate login credentials calling SCHEMA2.validate_user using `APEX_UTIL.IS_LOGIN_PASSWORD_VALID (p_username => v_username, p_password => v_password);` In both cases we receive Internal error. I check the DEBUG but nothing indicates issue. It seems to me to be related to session State Protection... Any help?
21-Sep-2018 02:11:PM by: eureka7
20-Sep-2018 03:21:PM by: wamarobert316
20-Sep-2018 03:20:PM by: juergen.schuster
Thanks for your inputs @art.rinberger. will wait for others response in this channel
19-Sep-2018 12:24:PM by: rprashu4u
Doh! You are correct- that works for Interactive Reports but not Interactive Grids. For an IG, you can declaratively set each column to be included in exports or when printing, so you could set the HTML to not export and the hidden, plain-text column to export. Unfortunately, hidden columns don't get a label, so that column would appear without a column header in the export. Maybe someone else knows a way around that, but I haven't seen it yet. :confused:
19-Sep-2018 12:21:PM by: art.rinberger
@art.rinberger Seems like this REQUEST condition works only for IR and not for IG. As in IG it wont set any REQUEST during download. Correct me if I am wrong
19-Sep-2018 12:04:PM by: rprashu4u
@rprashu4u There is no way to strip the HTML from a column only for download. However, if you already have a plain-text version of the same data, you could add that column to the IG query and give the two columns opposite PL/SQL conditions. For the HTML column, it would look something like this: `NVL(:REQUEST,'EMPTY') NOT IN('CSV','XLS','PDF','XML','RTF','HTMLD')` .
19-Sep-2018 11:50:AM by: art.rinberger
Here's the answer, directly from Christian Neumueller and David Peake on the Apex team: we had to desupport wwv_flow_custom_auth_std.logout for security reasons. You can get the expected behavior like this: 1. Add an application item, e.g. G_LOGOUT_URL 2. In the authentication scheme's Post-Logout URL region, enter Go To: URL URL: &G_LOGOUT_URL. 3. You need to set G_LOGOUT_URL, based on the user's login method and the network. I would probably do that in a Post-Authentication procedure. 4. The normal logout via apex_authentication.logout will perform the substitution and redirect to the value you set for G_LOGOUT_URL.
19-Sep-2018 11:33:AM by: j4john
working now. Thanks
19-Sep-2018 10:28:AM by: anjlesh8
Hi APEXPERTS, I have an interactive grid with one Display on Column which has HTML tags in it used for formatting. I used the setting "Escape Special Character" to No so that the HTML tags won't get displayed in the report. But the issue is whenever I export the data to CSV this HTML character gets added in CSV file. Any option to strip the HTML's during export? Thanks,
19-Sep-2018 10:21:AM by: rprashu4u
also I wouldn’t uppercase the password
19-Sep-2018 10:12:AM by: maxime_tremblay
the parameters need to be `p_username` and `p_password`, try renaming them. >This function must return a boolean to the login procedure that calls it. It has 2 input parameters ‘p_username’ and ‘p_password’ that can be used to access the values an end user entered on the login page.
19-Sep-2018 10:10:AM by: maxime_tremblay
thanks ,its working now .
19-Sep-2018 08:38:AM by: anjlesh8
now i am getting Invalid Login Credentials
19-Sep-2018 08:34:AM by: anjlesh8
function my_authentication ( p_username in varchar2, p_password in varchar2 ) return boolean is l_user users.username%type := p_username; l_pwd users.password%type :=p_password; l_value varchar2(400); begin select 1 into l_value from users where username = l_user and password =l_pwd ; return true ; exception when NO_DATA_FOUND then return false; end;
19-Sep-2018 08:33:AM by: anjlesh8
now i have changed my function
19-Sep-2018 08:33:AM by: anjlesh8
You need to change the formal parameters of this function. As the online doc says: This function must return a boolean to the login procedure that calls it. It has 2 input parameters 'p_username' and 'p_password' that can be used to access the values an end user entered on the login page.
19-Sep-2018 08:11:AM by: cneumuel
I want to create custom authentication in oracle apex , i have created one function and written in plsql section of custom authentication scheme, in function name i have written authenticate_user, when i am try to login it showing error wrong number of argument. function : FUNCTION authenticate_user(username_in IN VARCHAR2 ,password_in IN VARCHAR2) RETURN BOOLEAN IS l_value NUMBER; l_returnvalue BOOLEAN; BEGIN BEGIN SELECT 1 INTO l_value FROM users WHERE 1 = 1 AND upper(users.username) = upper(username_in) AND upper(users.password) = upper(password_in); EXCEPTION WHEN no_data_found OR too_many_rows THEN l_value := 0; WHEN OTHERS THEN l_value := 0; END; l_returnvalue := l_value = 1; RETURN l_returnvalue; END; kinldy suggest what is missing. thanks ,
19-Sep-2018 05:51:AM by: anjlesh8
Thanks again Maxime. I know they're desupported, which is the reason for my question. apex_authentication.logout entry doesn't do the same job:
18-Sep-2018 11:14:PM by: j4john
18-Sep-2018 10:14:PM by: maxime_tremblay
This might help you: > The API calls to wwv_flow_custom_auth_std.logout, wwv_flow_custom_auth_std.logout_then_go_to_page, wwv_flow_custom_auth_std.logout_then_go_to_url, and apex_custom_auth.logout are desupported and will raise a runtime error instead of logging out from the Oracle Application Express session. Instead, use the apex_authentication.logout entry point.
18-Sep-2018 10:13:PM by: maxime_tremblay

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
G. Krieger
21-Sep-2018 08:08
Double-click on link to IR creates "duplicate row" in apex_application_page_ir_rpt/wwv_flow_workshee
0 replies
21-Sep-2018 07:59
Random slow page load/refresh with Apex application
1 replies - last reply: 21-Sep-2018 09:37- by: 100ea4b1-6f48-4553-8e92-474adc7711e3
Denes Kubicek
21-Sep-2018 07:12
Error installing application
0 replies
Jozef Demovic
21-Sep-2018 07:00
APEX 18.1 - Two IGs with tab container scroll down - missing rows
1 replies - last reply: 21-Sep-2018 13:36- by: John Snyders-Oracle
21-Sep-2018 01:45
Exporting Shared commponents to different application
2 replies - last reply: 21-Sep-2018 08:08- by: fac586
21-Sep-2018 00:35
How to set application UI parameters through iframe
1 replies - last reply: 21-Sep-2018 04:29- by: Fernando Lima
20-Sep-2018 21:03
Oracle APEX Universal Theme PDF Print Issue
1 replies - last reply: 21-Sep-2018 07:08- by: BluShadow
20-Sep-2018 19:56
Mod Security and APEX Application Import
0 replies
20-Sep-2018 19:09
APEX (18.1) Installation on Solaris (11.3) using ORDS (18.2) in Oracle Web Logic Server (
0 replies
20-Sep-2018 17:50
Session Timeout in Kiosk Mode
0 replies
20-Sep-2018 16:56
APEX Checklist Manager - need "Contributor" privileges
0 replies
20-Sep-2018 16:32
how to access the apex which is running in PDB?
0 replies
20-Sep-2018 15:48
How do I branch back to a page with the new primary id that is created
2 replies - last reply: 20-Sep-2018 18:49- by: Idkfa2
20-Sep-2018 15:24
getting &amp instead of & in mail content using APEX_MAIL.SEND
0 replies
20-Sep-2018 14:50
Internal Error while creating user in another workspace with apex_util.create_user and login
0 replies
20-Sep-2018 14:49
GET/PUT apex rest data to another database
3 replies - last reply: 21-Sep-2018 09:15- by: Kiran Pawar
20-Sep-2018 13:37
Calling a function from different Database to Oracle Apex
4 replies - last reply: 21-Sep-2018 05:21- by: Billy~Verreynne
20-Sep-2018 13:09
Custom authentication scheme - max character in pl/sql
2 replies - last reply: 21-Sep-2018 01:29- by: Scott Wesley
20-Sep-2018 09:40
REST Web Service
1 replies - last reply: 20-Sep-2018 15:54- by: Kiran Pawar
Sasha Gomanuk
20-Sep-2018 03:01
Will Oracle scheme delete&import invalidate Apex workspace?
4 replies - last reply: 20-Sep-2018 15:06- by: Sasha Gomanuke
19-Sep-2018 19:07
Apex 18c Head Map Chart (Tree Chart)
2 replies - last reply: 20-Sep-2018 19:06- by: P.Huang
Mónica Godoy
19-Sep-2018 15:37
4 replies - last reply: 20-Sep-2018 16:19- by: Mónica Godoy
Bernhard FW
13-Sep-2018 06:08
Interactive GRID - download -> CSV -> email - populate email-receiver, sender, cc, subj. from page i
0 replies
11-Sep-2018 14:58
function apex.ajax.clob desupported or deprecated in APEX 18.1
1 replies - last reply: 21-Sep-2018 10:04- by: jmarc
Bernard Abell
30-Aug-2018 05:06
IR report format - Excel
4 replies - last reply: 21-Sep-2018 09:29- by: Bernard Abella


Shakeeb Rahman    Other
Font APEX now publicly available on Github
20-Sep-2018 16:52:07 by: Juergen Schuster
Maxime Tremblay    Other
18.2 on on September 22nd
19-Sep-2018 20:12:55 by: Juergen Schuster
mike hichwa    Other
18.2 to be Released Next Month
APEX 18, Press
08-Sep-2018 16:53:27 by: Jackie Mcilroy
Rodrigo Mesquita  
What you shouldn't do with Forms Migrations
Forms (Oracle Forms)
21-Sep-2018 13:24:54 by: Juergen Schuster
Marko Gorički    
New Plug-in: Code Editor in your APEX App
21-Sep-2018 13:18:04 by: Juergen Schuster
Sylvain Martel    Other
New Video: APEX and EBS
EBS, Videos
20-Sep-2018 17:03:08 by: Juergen Schuster
Juergen Schuster    Other
There is a new Slack channel: #forms_migration
Forms (Oracle Forms), Slack
20-Sep-2018 15:22:12 by: Juergen Schuster
Jorge Rimblas    Other
Webinar: Report Templates - The Definitive Guide
Reports, Webinar
19-Sep-2018 20:50:54 by: Juergen Schuster
Scott Wesley  
Hide a region on "no data found"
Dynamic Actions, Reports
17-Sep-2018 14:26:17 by: Juergen Schuster
Trent Schafer  
Save Interactive Grid with errors
Dynamic Actions, Interactive Grid
17-Sep-2018 14:21:09 by: Juergen Schuster
Joel Kallman    
Beyond the Database
APEX 18, Press, REST
16-Sep-2018 17:38:33 by: Juergen Schuster
JMJ Cloud Austin  
Handling SMS Text message
Interfaces, ORDS, REST
15-Sep-2018 18:10:51 by: Juergen Schuster
Richard Martens    Other
Universal Theme Poster
Universal Theme
15-Sep-2018 17:41:45 by: Juergen Schuster
Lucas Rayner  
Icons in Interactive Reports
Font-Icons, Interactive Report
15-Sep-2018 00:41:15 by: Jackie Mcilroy
Anton Nielsen  
Search Engine Optimisation with APEX
14-Sep-2018 16:38:51 by: Juergen Schuster
Marko Gorički  
Set default values with Dynamic Action
Dynamic Actions, Interactive Grid
14-Sep-2018 16:19:14 by: Juergen Schuster
Scott Wesley  
Show any information anywhere in your APEX page
Dynamic Actions
14-Sep-2018 09:27:07 by: Juergen Schuster
Matt Mulvaney  
Interactive Grid Undocumented Features
Interactive Grid
13-Sep-2018 17:05:01 by: Jackie Mcilroy
Chris Jansen    Other
Chrome Extension: SMART4Solutions - APEX Plugin
Application Builder, Page Designer
13-Sep-2018 01:37:36 by: Jackie Mcilroy
Matt Mulvaney    Other
Chrome Extension: APEX Page Designer Tab Lock
Application Builder, Page Designer
13-Sep-2018 01:34:42 by: Jackie Mcilroy
Rodrigo Mesquita    
New Plug-in: Hide Interactive Grid Toolbar
Interactive Grid, Plug-ins
12-Sep-2018 16:24:40 by: Juergen Schuster
karen cannell  
Universal Theme Events
Dynamic Actions, Universal Theme
12-Sep-2018 00:16:41 by: Jackie Mcilroy
Dimitri Gielis  
Increase Max Web Service Requests in APEX 18.1
11-Sep-2018 02:40:05 by: Jackie Mcilroy
Scott Wesley  
Enhanced Error Handling Function with Logger
API, Debugging, Error
11-Sep-2018 02:35:06 by: Jackie Mcilroy
Jorge Rimblas    Other
Video: JavaScript and CSS for PL/SQL developers
CSS, JavaScript, Videos
10-Sep-2018 19:59:43 by: Juergen Schuster
Anton Scheffer    
New Plug-in: Excel into Collections
Excel, Plug-ins
10-Sep-2018 13:36:42 by: Juergen Schuster
Marko Gorički    Other
New Podcast: Marko Gorički, Yes he can!
09-Sep-2018 17:42:42 by: Juergen Schuster
Lino Schildenfeld    Other
AUSOUG Webinar Series Recordings Available
08-Sep-2018 02:12:55 by: Jackie Mcilroy
Adrian Png    
APEX used in Research Environments
08-Sep-2018 00:58:38 by: Jackie Mcilroy
Jeffrey Kemp  
Using apex_item.checkbox2 with Multiple Identifiers
07-Sep-2018 01:21:12 by: Jackie Mcilroy
Carsten Czarski  Other
Video: Web Source Modules / REST Enabled SQL, Office Hours
APEX 18, REST, Videos
07-Sep-2018 01:09:53 by: Jackie Mcilroy
Christian Rokitta  
Universal Theme Touch Gestures Bug Fix
APEX 18, Bugs, Universal Theme
06-Sep-2018 00:40:32 by: Jackie Mcilroy

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20