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: 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?
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?
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 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 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_
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
I'm creating a new web source module, passed header and url parameters. REST API is working in Postman, but APEX 18.2 in is giving "Discovery error: HTTP 400: Bad request" and server response shows "<Response> <status> <version>1.0.0</version> <code>-5</code> <msg>Invalid Parameter in Request</msg> <total>0</total> <page>0</page> <pagesize>0</pagesize> </status> </Response>". How do I see the request generated by Web Source Discovery?
09-Oct-2018 04:40:PM by: aragorniiit

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
0 replies
15-Oct-2018 02:11
5 replies - last reply: 15-Oct-2018 08:46- by: fac586
14-Oct-2018 14:22
display item to show in page load
1 replies - last reply: 14-Oct-2018 14:28- by: Alli Pierre Yotti
Javier Porrat
14-Oct-2018 07:55
Plugins compatibility issue
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
5 replies - last reply: 14-Oct-2018 11:06- by: Man Michel
13-Oct-2018 16:26
Properties disappeared from the Source Section for some items in the page - At design time
1 replies - last reply: 13-Oct-2018 20:35- by: fac586
13-Oct-2018 15:12
Interactive Grid - Lastpass icons
4 replies - last reply: 15-Oct-2018 04:38- by: AquaNX4
13-Oct-2018 13:27
Interactive Grid - Custom Row Action
15 replies - last reply: 14-Oct-2018 16:10- by: Alli Pierre Yotti
13-Oct-2018 10:44
Partner Application Name??
1 replies - last reply: 13-Oct-2018 10:57- by: Alli Pierre Yotti
13-Oct-2018 08:25
Vertical scrollbar, too much space on footer
0 replies
Bas de Klerk
12-Oct-2018 16:08
utl_http.request on ssl site fails with ORA-29024
9 replies - last reply: 15-Oct-2018 08:11- by: Pavel_p
12-Oct-2018 15:34
Passing mulit-select data to a stored procedure in APEX 5.1.4
1 replies - last reply: 12-Oct-2018 15:52- by: Alli Pierre Yotti
12-Oct-2018 14:56
Apex tree attributes are lost after exporting from 5.1 and importing to 18.2
0 replies
12-Oct-2018 13:23
Legacy Calendar in Apex 5.1
4 replies - last reply: 15-Oct-2018 09:30- by: rambo81
12-Oct-2018 13:13
How to change the error message Invalid login credentials if not on user table
3 replies - last reply: 12-Oct-2018 15:47- by: sect55
12-Oct-2018 12:54
Unable to edit property of Column Header
4 replies - last reply: 15-Oct-2018 06:50- by: user12987400
12-Oct-2018 11:09
Setting page item value
4 replies - last reply: 13-Oct-2018 19:35- by: fac586
12-Oct-2018 10:35
Multiple item value DAs
3 replies - last reply: 15-Oct-2018 08:13- by: DejanH
12-Oct-2018 06:47
How to make row read-only depending on column value in interactive grid apex 18
5 replies - last reply: 14-Oct-2018 15:30- by: Alli Pierre Yotti
12-Oct-2018 05:55
Manage Workspace not displaying all the schema
3 replies - last reply: 15-Oct-2018 05:02- by: 613783
10-Oct-2018 19:07
How to generate JSON file on demand from Apex 5.1 on 11.2 database
8 replies - last reply: 14-Oct-2018 21:41- by: Pavel_p
09-Oct-2018 05:55
IG get the value of previous column?
8 replies - last reply: 12-Oct-2018 14:36- by: Sven W.
08-Oct-2018 13:19
Universal Theme - Dynamically set active tab
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'?
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
6 replies - last reply: 13-Oct-2018 12:44- by: joelkallman-Oracle


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

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20