Slack

@peterraganitsch, @shaun.mauer You can use demo/demo for credentials to the app Thanks
15-Oct-2018 04:01:PM by: eureka7
@peterraganitsch, @shaun.mauer I tried to use "Switch in Session" option but doesn't work. As the help said I added a second button "switch Authentication" on login page and run it. Of course since we are not logged in yet it branches back to login page. I then logged in using regular login button. When I tried to call `apex_util.create_user` same problem. I tried to reproduce on http://apex.oracle.com|apex.oracle.com but seems that it's not allow to call APIs in page processes: https://apex.oracle.com/pls/apex/f?p=84551:2
15-Oct-2018 03:57:PM by: eureka7
Hi everyone, I have a problem with the shutlle list I need to store more then 4000bytes and when i check the values from the shuttle list i get this error "Length of value to be encrypted may not exceed 4000 bytes." Is there any workarounds or a plugin i can use?
15-Oct-2018 11:21:AM by: shaier
Our dev environment has been patched to 5.1.4, however our qa/stage/prod etc environments are still on 5.1.1. I've done a full application export/install between dev/qa and it appears to work without issue. Anything I should be looking out for in particular or should double-check?
14-Oct-2018 07:06:PM by: trevorh
there's a great blogpost from John Snyders: http://hardlikesoftware.com/weblog/2017/01/05/passing-data-in-and-out-of-apex-dialogs/ beginning of post >An APEX dialog page is like any other APEX page except that it runs in an iframe in a dialog inside another APEX page. So in general the mechanisms for sharing data between pages should be the same. One page can access data entered on another page if that data has been saved in session state or an APEX collection or if it has been committed to a database table. >What should not be done is the dialog page directly accessing the DOM or JavaScript context of its parent page to read or write data. The reason is that a dialog is a reusable component that shouldn’t care or know anything about what page it is opened from. This is a general principal of dialogs in any GUI system. Also a dialog should not directly manipulate data of the caller because generally there is a Cancel button and if the user chooses to cancel then any changes made should have no effect. end of post: >Why not just have the dialog page branch to the parent page? Because that breaks the rule stated in the beginning about dialogs not knowing from where they were opened.
12-Oct-2018 01:35:PM by: maxime_tremblay
I see. What are the reasons for this, if you don't mind?
12-Oct-2018 12:34:PM by: ross.scottish
While it works you should not use a branch to close a modal to go back to the parent You should use a close modal action along with a dialog closed da on the parent page
12-Oct-2018 11:07:AM by: maxime_tremblay
Anyone ever come across a white webpage when using a simple branch to go from a modal page back to the parent normal page?
12-Oct-2018 09:58:AM by: ross.scottish
@eureka7 @shaun.mauer starting with APEX 18.1 you can have multiple Authentication Schemes in a single Application and switch them for your session by passing APEX_AUTHENTICATION=scheme name in a URL’s request parameter.
12-Oct-2018 07:58:AM by: peterraganitsch
@eureka7 - Would something like this help? http://roelhartman.blogspot.com/2017/10/using-multiple-authentication-schemes.html
12-Oct-2018 06:31:AM by: shaun.mauer
Hi all, I am using the following custom authentication in apex 18.1.0 (just code body) The idea is to allow login using apex account if for any reason domain/LDAP authentication does not work. The problem is, if I log in using domain password, I cannot use `apex_util.create_user` api I get `apex_error_code: APEX.USER.NOT_ADMIN` although I am Apex administrator. I tried using apex account authentication and it worked fine. So is there a way to connect with LDAP authentication and still be able to call apex_util.create_user? ```begin l_user := l_domain || '\' || p_username; DBMS_OUTPUT.PUT_LINE ('User: '||l_user ); l_session := DBMS_LDAP.init (l_ldap_server, l_ldap_port); -- start session l_retval := DBMS_LDAP.simple_bind_s (l_session, l_user, p_password); -- auth as user l_retval := DBMS_LDAP.unbind_s (l_session); -- unbind dbms_output.put_line ('LDAP-Auth' ); return true; exception when others then dbms_output.put_line ( 'Issue in LDAP session: '||sqlerrm||chr(13)||dbms_utility.format_error_backtrace ); dbms_output.put_line ('Apex-Auth'); begin return apex_util.is_login_password_valid (p_username => p_username, p_password => p_password); exception when others then return false; end; end;```
11-Oct-2018 07:30:PM by: eureka7
@ross.scottish isn’t copying very easy? But no, there isn’t any other way. Pages cannot be renumbered.
11-Oct-2018 05:20:PM by: peterraganitsch
Is there an easier way to renumber a page other than copying it to the correct number?
11-Oct-2018 04:22:PM by: ross.scottish
ok, thanks...i did try that but unfortunately i still have the issue...thinking i will just create a new form with the fields i need to create
11-Oct-2018 01:33:PM by: nmmisd
no problem :slightly_smiling_face:
11-Oct-2018 07:14:AM by: cneumuel
Awesome. It worked. Thanks alot :slightly_smiling_face:
11-Oct-2018 07:14:AM by: ashwinrao
Thought so. Coincidentally, I fixed a bug yesterday that limits this to 4 digits. Please enter a smaller number.
11-Oct-2018 07:13:AM by: cneumuel
it has been set to "99999999"
11-Oct-2018 07:11:AM by: ashwinrao
@ashwinrao Go to Instance Admin > Manage Instance > Security. It is in the region "Development Environment Settings"
11-Oct-2018 07:10:AM by: cneumuel
where do i find this option ? @cneumuel
11-Oct-2018 07:09:AM by: ashwinrao
@ashwinrao Did you set "Account Password Lifetime (days)" to some very big number?
11-Oct-2018 07:06:AM by: cneumuel
Hi guys, I am trying to update workspace user logging in as ADMIN , but i am encountering error as "Error updating user. ORA-01841: (full) year must be between -4713 and +9999, and not be 0" . Any idea how to overcome this.
11-Oct-2018 05:18:AM by: ashwinrao
Delete the IG and create a new one
10-Oct-2018 08:18:PM by: h.hopkirk
not sure what you mean by recreate the region (or page)?
10-Oct-2018 07:50:PM by: nmmisd
It's a known bug(I think). Just recreate the region and if it still shows try the page.
10-Oct-2018 07:49:PM by: h.hopkirk
Hello, I have an Interactive Grid with Add Row turned on. However, when I select add row, in the column I have designated as the PK, I get a default value of t1001, t1002 and so on for each new row I add. Is there a way where I can have that value hidden from the user so they don't get confused? I tried setting a default, but the t1001 shows instead. I am on 5.1
10-Oct-2018 07:47:PM by: nmmisd
Can IG work with a table that contains 1Million Records : YES Can IG Display 1 Million Records all at once : I doubt ANYTHING could do that. IG works with record sets and pagination.You can filter and retrieve the records the user is interested in and allow them to operate directly on those. If you customer really wants to display 1 Million records all at once, then i think it's a customer expectation problem rather as that's insanity.
10-Oct-2018 06:43:PM by: doug.a.gault
Hi, does IG can work with 1 million records or not. My client need this
10-Oct-2018 06:11:PM by: vjekoslav
Thanks @maxime_tremblay However, I was looking something similar to file browse item plugin.
10-Oct-2018 12:43:PM by: ashwinrao
Hi Joel. Thanks for the feedback
10-Oct-2018 12:22:PM by: shaun.mauer
Did you have a look at the dropzone plugin? https://github.com/Dani3lSun/apex-plugin-dropzone
10-Oct-2018 12:17:PM by: maxime_tremblay
Hi Shaun - yes, the new certification is actively being developed now. We hope to have something out by the end of the calendar year, but I can't provide 100% guarantee that we'll make this date.
10-Oct-2018 12:11:PM by: joelkallman
Hi Guys, Did anyone come across ajax file upload plugin compatible with universal theme . I tried using this https://apextips.blogspot.com/2011/03/ajax-file-upload.html plugin in universal theme , but it is not working and throwing error in console. Any pointers?
10-Oct-2018 11:53:AM by: ashwinrao
Can you replicate this in an apex.oracle.com workspace. It might help to look at it directly.
10-Oct-2018 11:07:AM by: jaughenbaugh
Hi Is it possible to highlight or change background color for all NULL fields in APEX 18.2 form?
10-Oct-2018 08:38:AM by: badanikareem
@cczarski @joelkallman @orcl_dpeake - Are there any plans to revive the Oracle Apex Certifications? The Oracle Education page states _At this time, there are no APEX Certifications available_ https://education.oracle.com/database-application-development/oracle-apex/product_172?certPage=true
10-Oct-2018 07:50:AM by: shaun.mauer
Could any one help me on this - function returning sql query error?
10-Oct-2018 05:17:AM by: sharma.harish1

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
Deepak Rawat
15-Oct-2018 09:25
Not able to connect from oracle 11.2.0 client to Oracle database 12.2 server DB (ora-28040 no matchi
Link
0 replies
wisers
15-Oct-2018 02:11
PL/SQL in APEX
Link
5 replies - last reply: 15-Oct-2018 08:46- by: fac586
BijuRajan6343
14-Oct-2018 14:22
display item to show in page load
Link
1 replies - last reply: 14-Oct-2018 14:28- by: Alli Pierre Yotti
Javier Porrat
14-Oct-2018 07:55
Plugins compatibility issue
Link
19 replies - last reply: 14-Oct-2018 17:55- by: Alli Pierre Yotti
Man Michel
14-Oct-2018 04:27
Change page title based on item
Link
5 replies - last reply: 14-Oct-2018 11:06- by: Man Michel
guarionex
13-Oct-2018 16:26
Properties disappeared from the Source Section for some items in the page - At design time
Link
1 replies - last reply: 13-Oct-2018 20:35- by: fac586
partlycloudy
13-Oct-2018 15:12
Interactive Grid - Lastpass icons
Link
4 replies - last reply: 15-Oct-2018 04:38- by: AquaNX4
partlycloudy
13-Oct-2018 13:27
Interactive Grid - Custom Row Action
Link
15 replies - last reply: 14-Oct-2018 16:10- by: Alli Pierre Yotti
Goutam.M-Orac
13-Oct-2018 10:44
Partner Application Name??
Link
1 replies - last reply: 13-Oct-2018 10:57- by: Alli Pierre Yotti
RobV62
13-Oct-2018 08:25
Vertical scrollbar, too much space on footer
Link
0 replies
Bas de Klerk
12-Oct-2018 16:08
utl_http.request on ssl site fails with ORA-29024
Link
9 replies - last reply: 15-Oct-2018 08:11- by: Pavel_p
mjondle
12-Oct-2018 15:34
Passing mulit-select data to a stored procedure in APEX 5.1.4
Link
1 replies - last reply: 12-Oct-2018 15:52- by: Alli Pierre Yotti
christof_b
12-Oct-2018 14:56
Apex tree attributes are lost after exporting from 5.1 and importing to 18.2
Link
0 replies
rambo81
12-Oct-2018 13:23
Legacy Calendar in Apex 5.1
Link
4 replies - last reply: 15-Oct-2018 09:30- by: rambo81
sect55
12-Oct-2018 13:13
How to change the error message Invalid login credentials if not on user table
Link
3 replies - last reply: 12-Oct-2018 15:47- by: sect55
user12987400
12-Oct-2018 12:54
Unable to edit property of Column Header
Link
4 replies - last reply: 15-Oct-2018 06:50- by: user12987400
anand_gp
12-Oct-2018 11:09
Setting page item value
Link
4 replies - last reply: 13-Oct-2018 19:35- by: fac586
DejanH
12-Oct-2018 10:35
Multiple item value DAs
Link
3 replies - last reply: 15-Oct-2018 08:13- by: DejanH
Kayal
12-Oct-2018 06:47
How to make row read-only depending on column value in interactive grid apex 18
Link
5 replies - last reply: 14-Oct-2018 15:30- by: Alli Pierre Yotti
613783
12-Oct-2018 05:55
Manage Workspace not displaying all the schema
Link
3 replies - last reply: 15-Oct-2018 05:02- by: 613783
Raviteja
10-Oct-2018 19:07
How to generate JSON file on demand from Apex 5.1 on 11.2 database
Link
8 replies - last reply: 14-Oct-2018 21:41- by: Pavel_p
Tomy_1969
09-Oct-2018 05:55
IG get the value of previous column?
Link
8 replies - last reply: 12-Oct-2018 14:36- by: Sven W.
user2003324
08-Oct-2018 13:19
Universal Theme - Dynamically set active tab
Link
8 replies - last reply: 12-Oct-2018 14:35- by: Gor_Mahia
R. Buitenhuis
01-Oct-2018 09:44
Does APEX works with 'Application Continuity'?
Link
1 replies - last reply: 12-Oct-2018 20:16- by: joelkallman-Oracle
Sasha Gomanuk
22-Sep-2018 12:10
Utilities-Database Administrator Login failed after upgrade from Apex 5 to18
Link
6 replies - last reply: 13-Oct-2018 12:44- by: joelkallman-Oracle

News

X
    
 
ImageNewsFavoriteForward
Jackie Mcilroy    Other
New Podcast: Jackie Mcilroy - The alien woman :-)
Podcast
Link
12-Oct-2018 18:05:12 by: Juergen Schuster
Doug Gault  
Remember your Tree state
Tree
Link
15-Oct-2018 15:50:01 by: Juergen Schuster
Mark Lancaster  
Export App as 5.1 version AFTER you have upgraded to 18
Installation
Link
15-Oct-2018 07:52:15 by: Juergen Schuster
Richard Martens    
LOV queries
LOVs
Link
13-Oct-2018 14:52:18 by: Juergen Schuster
Joel Kallman  
Static recourses now on Content Delivery Network
APEX 18, Internet
Link
12-Oct-2018 17:59:04 by: Juergen Schuster
Carsten Czarski  
Interactive Grid on Web Source Modules
APEX 18, Interactive Grid, REST
Link
12-Oct-2018 09:48:25 by: Juergen Schuster
Monica Godoy  
Team Development
Link
12-Oct-2018 02:52:36 by: Jackie Mcilroy
Anthony Rayner    Other
Webinar: APEX Office Hours - Dynamic Actions, 18 Oct 10am EDT
Dynamic Actions, Webinar
Link
12-Oct-2018 02:47:59 by: Jackie Mcilroy
Anton Nielsen  Other
Video: Peer Code Reviews in APEX
Videos
Link
12-Oct-2018 02:43:15 by: Jackie Mcilroy
Jeffrey Kemp    
Why I'm on Oracle / APEX
Press
Link
11-Oct-2018 11:28:10 by: Juergen Schuster
Joel Kallman  
Integrate iTunes via REST
APEX 18, REST
Link
11-Oct-2018 07:03:37 by: Juergen Schuster
Scott Wesley  Other
Workspace Activity Logs
Link
10-Oct-2018 21:48:03 by: Jackie Mcilroy
John Snyders  
IG Cookbook Update for 18.2
APEX 18, Interactive Grid
Link
10-Oct-2018 21:45:55 by: Jackie Mcilroy
Anton Nielsen  Other
Webinar: How to Do Peer Code Reviews, Today 2pm, ET
Webinar
Link
10-Oct-2018 09:30:40 by: Juergen Schuster
Peter Raganitsch  
Reverse proxy APEX and ORDS
ORDS
Link
08-Oct-2018 23:04:02 by: Jackie Mcilroy
Sandro Ferreira  
Dark Mode for APEX
Universal Theme, User Interface
Link
08-Oct-2018 19:03:32 by: Juergen Schuster
Jackie Mcilroy  
apex.world behind the scenes
apex.world
Link
08-Oct-2018 15:32:52 by: Juergen Schuster
Juan Lopez Garcia  
Universal Theme for mobile Apps
APEX 18, Mobile, Universal Theme
Link
08-Oct-2018 10:48:26 by: Juergen Schuster
Peter Raganitsch    
10 recommendations for faster development
Link
08-Oct-2018 10:43:55 by: Juergen Schuster
Lino Schildenfeld    Other
New Conference: AUSOUG Connect 2018, Australia, Perth & Melbourne
Conferences
Link
08-Oct-2018 00:53:41 by: Jackie Mcilroy
Peter Raganitsch  
Deploy ORDS on Tomcat in a Subdirectory
ORDS
Link
06-Oct-2018 01:41:20 by: Jackie Mcilroy
John Snyders  Other
Video: Interactive Grid, Office Hours
Interactive Grid, Videos
Link
05-Oct-2018 17:35:26 by: Juergen Schuster
Anton Nielsen  Other
Video: Working in Teams
Videos
Link
05-Oct-2018 17:23:54 by: Juergen Schuster
JMJ Cloud Austin  
Accessing AWS S3 with API Gateway & Lambda
Cloud, REST
Link
04-Oct-2018 20:20:58 by: Jackie Mcilroy
Juergen Schuster    Other
New Conference: APEX Connect 2019, Germany, Bonn
Conferences
Link
04-Oct-2018 11:33:02 by: Juergen Schuster
Joel Kallman  
Forms Modernization Discussion
Forms (Oracle Forms)
Link
03-Oct-2018 21:31:45 by: Jackie Mcilroy
Rodrigo Mesquita  
Plug-ins for Beginners
Plug-ins
Link
03-Oct-2018 19:12:05 by: Jackie Mcilroy
Jackie Mcilroy    Other
Newsletter #28 is out!
Newsletter
Link
03-Oct-2018 18:50:21 by: Jackie Mcilroy
Anton Nielsen    Other
Webinar: Code Reviews in APEX Dev Teams
Webinar
Link
03-Oct-2018 16:02:15 by: Jackie Mcilroy
Trent Schafer  
Handling Paste Events
Dynamic Actions
Link
03-Oct-2018 01:59:44 by: Jackie Mcilroy
Peter Raganitsch  
Automatically trim spaces for Items
Items
Link
02-Oct-2018 15:57:31 by: Juergen Schuster
Scott Wesley  
Remove duplicates from APEX collection
Link
02-Oct-2018 12:18:15 by: Juergen Schuster

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20