Bulk Updating Interactive Grid Records
23-Mar-2017 06:25:PM by: christoph
I managed to solve it by creating an ID field which value(s) comes from a sequence in a before trigger table. Also, this ID is my primary key on Apex page, even though my real PK is based on two other columns. I also stopped using ROWID as primary key. In my customized PL/SQL routine, I am returning each newly inserted ID into a variable which will return to PL/SQL routine of my editable interactive grid.
23-Mar-2017 05:42:PM by: franklin.jr
Dear friends, a small but boring problem with some editable interactive grids. Sometimes I have a "no data found" error after creating new rows and saving data, and I can't find its reason. Is there any common reason for that? Some details might help you: Apex 5.1, table has its PK (two fields). I tried using these fields, and also ROWID, to uniquely identify them. It executes a PL/SQL code for each row because there's some business logic to test before saving, so my DML is manual. Please notice I did some debugging but it is still not clear to me. (It updates with no problems, error comes while inserting.) Thanks in advance for your help.
23-Mar-2017 03:41:PM by: franklin.jr
Yes, you´re right, that was a bad idea... I think the only right solution is the one that @turntablez suggested
23-Mar-2017 11:54:AM by: apex_student
Tomorrow there will be a planned outage. Slack is not affected though.
23-Mar-2017 09:29:AM by: juergen.schuster
Question about the "new" browser requirements for apex 5.1 _"Oracle Application Express supports the current and prior major release of Google Chrome, Mozilla Firefox, Apple Safari, Microsoft Internet Explorer and Microsoft Edge."_ What exactly does _"current and prior major release"_ mean? Is it possible / necessary to show a "browser outdated" warning? How to implement that without the now desupported browser condition types?
23-Mar-2017 07:33:AM by: sclauss
@apex_student AFAIK, the application alias is only used for the initial connection to the app, then the app ID is used. At least it seems to work that way with my apps. If you tried this, you'd also have to change any PREPARE_URL commands so they use the alias.
23-Mar-2017 01:38:AM by: sstryker58
@maxime_tremblay @dgielis Thanks :slightly_smiling_face:
22-Mar-2017 09:42:PM by: trent
@trent and yes it's on May 24th as @dgielis said
22-Mar-2017 09:21:PM by: maxime_tremblay
I thought it was May 24th
22-Mar-2017 08:11:PM by: dgielis
@urhlednik I just stumble on this plugin, which you might find helpful Pretius Client Side Validation (1.1) by @bostrowski it's on
22-Mar-2017 04:50:PM by: maxime_tremblay
creating a page process of type "Reset Pagination" doesn't work with IR?
22-Mar-2017 03:01:PM by: pichalite
@urhlednik you could do it using a PL/SQL DA that would set/return a count into an item, then you could have another javascript action that would check if the count equals 0, and if not display an error message The validation should also be done on server side to make sure nothing was created in the meantime You can have a look at the and apex.item API references, you might be able to leverage some of the functions
22-Mar-2017 01:57:PM by: maxime_tremblay
i have next question: with client side live validation -> live checkup if item exist in database before you submit values -- "on the fly" -- i found how to validate regex expression live before submit but have not found how to validate items live if it matches with database record for certain item. thanks for any hints..
22-Mar-2017 01:08:PM by: urhlednik
Has anyone observed report pages in apex that take a very long time? When trapping the query in Enterprise Manager I see a PL./SQL block that does NOT match the query on the page. The PL/SQL block looks like something internal to Apex and begins with declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.vc_arr; begin...
22-Mar-2017 01:06:PM by: bille67
@shaun.mauer Thank you :slightly_smiling_face:
22-Mar-2017 08:38:AM by: cremy
@cremy check the APEX_UTIL API
22-Mar-2017 08:33:AM by: shaun.mauer
hi, in which tables is the data from the manage users and groups section ? and can i normaly update the data with plsql ? I have an application, and a superuser should update groups from a user or insert a new user
22-Mar-2017 08:11:AM by: cremy
22-Mar-2017 07:13:AM by: shaun.mauer
@ritika @roelhartman @maxime_tremblay dont forget the DA actions are now asynchronous, another option would be one Javascript action that disables the buttons (using jquery), performs an AJAX callback to the PL/SQL procedure and then enables the buttons again (using jquery)
22-Mar-2017 07:12:AM by: shaun.mauer
...well all the values of the selected rows
22-Mar-2017 03:19:AM by: castrogeneris
I need to read a value of a column in interactive grid
22-Mar-2017 03:19:AM by: castrogeneris
hi, in an interactive grid I have an approved column, how could I approve all? is that available in Interactive Grid?
22-Mar-2017 02:24:AM by: castrogeneris
When is the next apexworld on air?
22-Mar-2017 12:04:AM by: trent
thanks a lot for the heads up. I would see how the mechanism that you delivered, can be reproduced in the production environment. great minds are impregnated with ideas and to conceive alternative solutions to entangled problem assumes brilliance. keep up the good work.:smile:
21-Mar-2017 08:58:PM by: m_yasir_ali
I hope you can reproduce it..
21-Mar-2017 07:37:PM by: sclauss
@m_yasir_ali I documented the steps within the demo page :wink:
21-Mar-2017 07:36:PM by: sclauss
But if you can share how what you did would be awesome! thanks
21-Mar-2017 06:12:PM by: gaspar
I have been playing with PDFObject to render the pdf in a non-modal dialog form, which has some advantages.. The main is that you can read .pdf documents from the Server filesystem or the client and has full access to Acrobat-like features like bookmarks, zooming, page fit, download, print, etc.. Also I have been playing with an "HTML" Solution that relies on the browser's capability to render the .pdf, like your solution.. In my case the requirements are not very clear... So I'll be waiting for a little bit longer..
21-Mar-2017 06:11:PM by: gaspar
@sclauss Good work at cracking that one..
21-Mar-2017 05:52:PM by: gaspar
@sclauss great work, However it would be beneficial if you could share the steps after pdf is uploaded and is displayed in the report.
21-Mar-2017 05:15:PM by: m_yasir_ali
added validations for all date types and min and max dates, min and max hours validations, and readonly option for both date Items if Range Date Picker Selected
21-Mar-2017 05:12:PM by: m_yasir_ali
Except for the "missing" title of the PDF Doc (in Chrome) it is sufficient for me :slightly_smiling_face:
21-Mar-2017 03:26:PM by: sclauss
21-Mar-2017 03:23:PM by: sclauss
@sclauss can you put the URL where you make it? I want to see how it Looks. Thanks
21-Mar-2017 03:23:PM by: pierre
@ritika DAs just like @roelhartman mentioned should work. Make sure that the PL/SQL action has the "Wait For Result" attribute set to "Yes"
21-Mar-2017 02:05:PM by: maxime_tremblay
no it doesnt work
21-Mar-2017 12:43:PM by: ritika
Sure - if you define the Dynamic Action itself onclick of that button.
21-Mar-2017 12:34:PM by: roelhartman
@roelhartman after disable button we can run pl\sql ?
21-Mar-2017 12:33:PM by: ritika
Hello everyone. I have an issue, where i have 2 interactive grids in regional display selectors. The toolbar of the interactive grid only shows on the one that is displayed on page load, when i click to look at the other that bar has gone. Any ideas?
21-Mar-2017 12:31:PM by: turntablez
Why not create a Dynamic Action with 3 Actions : 1. Disable button 2. Do your PL/SQL thing (Wait for Result should be set to "Yes") 3. Enable button or am I missing something (or you didn’t mention everything)?
21-Mar-2017 12:13:PM by: roelhartman
But this is creating a time lag between the button clicked and it becoming disabled
21-Mar-2017 11:38:AM by: ritika

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
23-Mar-2017 21:32
•Ajax call returned server error ORA-20987: APEX - ORA-22816: unsupported feature with RETURNING c
0 replies
23-Mar-2017 18:21
Alter CSS of an Interactive Grid cell.
1 replies - last reply: 23-Mar-2017 22:54- by: John Snyders-Oracle
23-Mar-2017 17:37
Interactive Grid validation NOT working
1 replies - last reply: 23-Mar-2017 17:48- by: PMON
23-Mar-2017 16:29
application builder no longer working, application do work
0 replies
23-Mar-2017 14:25
Gantt Chart is not showing up on screen
0 replies
23-Mar-2017 12:52
copy region/item to other page
0 replies
23-Mar-2017 11:26
Series name for a link in a chart
0 replies
23-Mar-2017 10:56
Copying Interactive Reports between users
3 replies - last reply: 23-Mar-2017 16:22- by: Bas de Klerk
Snow Wang
23-Mar-2017 05:40
How to focus an item in APEX jQuery Mobile Smartphone interface?
2 replies - last reply: 23-Mar-2017 11:59- by: Snow Wang
23-Mar-2017 00:57
How to implement tooltips on Side Navigation Menu List icons
4 replies - last reply: 23-Mar-2017 23:26- by: PPlatt
23-Mar-2017 00:15
Checksum format error while creating APEX application
1 replies - last reply: 23-Mar-2017 10:45- by: Mahmoud_Rabie
Rajiv N
22-Mar-2017 23:50
Upgrade APEX 4.0 to APEX 5.1
1 replies - last reply: 23-Mar-2017 10:49- by: Mahmoud_Rabie
22-Mar-2017 21:32
Problem with Page Process accessing a page item return_value
5 replies - last reply: 23-Mar-2017 11:51- by: PhilMan2
22-Mar-2017 19:45
Global Items Visible to Triggers?
2 replies - last reply: 22-Mar-2017 21:56- by: Pavel_p
22-Mar-2017 17:26
An update view fire ORA-01031: insufficient privilege
5 replies - last reply: 23-Mar-2017 12:55- by: jmniard
Cheney Shue
22-Mar-2017 16:06
CSS and JS path of Plug-In
1 replies - last reply: 23-Mar-2017 10:56- by: Mahmoud_Rabie
21-Mar-2017 16:42
Apex 5.1 Badge list
12 replies - last reply: 23-Mar-2017 18:32- by: Bozzy-Oracle
20-Mar-2017 19:08
Question regarding stacking items in a master detail to reduce space.
1 replies - last reply: 23-Mar-2017 18:05- by: trishl
A Raj
18-Mar-2017 00:31
Displaying results from dynamic SQL joining multiple tables
13 replies - last reply: 23-Mar-2017 21:34- by: Mike Kutz
10-Mar-2017 09:51
Show PDF with On Demand PLSQL procedure
3 replies - last reply: 23-Mar-2017 14:38- by: BruinsmaM
08-Mar-2017 19:48
Bulk edit in interactive grid
2 replies - last reply: 23-Mar-2017 14:46- by: CMRuepprich
08-Mar-2017 07:12
Apex 5.1 Universal theme sidebar navigation menu tooltip
1 replies - last reply: 23-Mar-2017 22:59- by: John Snyders-Oracle
03-Mar-2017 16:29
Oracle Apex Calendar Drag&Drop
4 replies - last reply: 23-Mar-2017 12:47- by: Baonerges
Mazin Abdulah
03-Mar-2017 10:29
ApEx 5.1 Create Report on Webservice
2 replies - last reply: 23-Mar-2017 12:25- by: kflood-Oracle
15-Apr-2016 17:02
Help please! Filter in Interactive Report with 'IN' operator
10 replies - last reply: - by:


Juergen Schuster    Other
On-Air Show: May 24th, All about Printing!
On Air,
23-Mar-2017 10:05:32 by: Juergen Schuster
Juergen Schuster    Other
Tomorrow (Friday), planned outage
23-Mar-2017 09:33:49 by: Juergen Schuster
Marc Sewtz    
5.2 Statement of Direction
APEX 5.2
01-Mar-2017 16:45:34 by: Juergen Schuster
Frank Hoogendoorn    
Low Code Story
22-Mar-2017 16:57:19 by: Juergen Schuster
Dirk Strack    
New Plug-in: Unzip Parallel Process
22-Mar-2017 14:00:09 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: Malaysia, Kuala Lumpur, permanent, on site, Working Visa
21-Mar-2017 15:29:20 by: Juergen Schuster
David Anderson  Other
Free APEX Security Videos
Security, Videos
20-Mar-2017 15:14:09 by: Juergen Schuster
Ivan Sabolić  
Page Template Right Side Column, change width
Universal Theme
18-Mar-2017 18:53:53 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: USA, Tampa, Florida, permanent, onsite
18-Mar-2017 17:33:27 by: Juergen Schuster
Vincent Morneau  Other
5.1 Material Design Theme
User Interface
17-Mar-2017 13:01:25 by: Juergen Schuster
Marko Gorički    
Master Detail with Interactive Report in 5.1
APEX 5.1, Interactive Report
17-Mar-2017 12:54:41 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: UK, Linlithgow, permanent
17-Mar-2017 10:19:13 by: Juergen Schuster
mike hichwa    Other
Generate Tables and Data in no time #orclquicksql
17-Mar-2017 08:01:49 by: Juergen Schuster
Vincent Morneau  Other
Geo Data Library for free
17-Mar-2017 00:28:55 by: Juergen Schuster
Scott Spendolini  Other
Free Webinar: Webservices for APEX
15-Mar-2017 14:29:23 by: Juergen Schuster
Ottmar Gobrecht    
New Plug-in: Count DHTMLX Gantt Chart
Charts, Plug-ins
15-Mar-2017 14:19:25 by: Juergen Schuster
Farzad Soltani  
Checkbox parsing in Interactive Reports via AJAX
AJAX, Interactive Report
14-Mar-2017 20:08:40 by: Juergen Schuster
Customizing chart colors in 5.1
APEX 5.1, Charts
14-Mar-2017 13:40:58 by: Juergen Schuster
Farzad Soltani    
New Plug-in: Count Down with flip effect
14-Mar-2017 10:54:32 by: Juergen Schuster
Carsten Czarski  
APEX Flashback Export
13-Mar-2017 19:15:42 by: Juergen Schuster
Scott Wesley  
Font APEX in APEX 5.0
APEX 5.0, Font
13-Mar-2017 19:10:25 by: Juergen Schuster
Marko Gorički    
New Plug-in: Advanced Slider
13-Mar-2017 07:30:44 by: Juergen Schuster
Scott Spendolini  
Low Code
10-Mar-2017 21:10:47 by: Juergen Schuster
Christoph Ruepprich  
Update Interactive Grid with JavaScript
Interactive Grid, JavaScript
10-Mar-2017 01:31:36 by: Juergen Schuster
Paul Thaden  
APEX REST: 2 Queries one Endpoint
08-Mar-2017 15:05:33 by: Juergen Schuster
Juergen Schuster  Other
New Job: USA, Dallas, permanent, onsite
07-Mar-2017 20:13:17 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: Albuquerque, USA, permanent, onsite
06-Mar-2017 23:18:44 by: Juergen Schuster
Adrian Png  
APEX in the Cloud for $5.- per month with full control
Cloud, Installation
06-Mar-2017 15:16:24 by: Juergen Schuster
Amr Abdeen  
Handling expired APEX session by message to user
06-Mar-2017 06:27:21 by: Juergen Schuster
Farzad Soltani    
New Plug-in: Notifications
05-Mar-2017 12:29:28 by: Juergen Schuster
christina moore    Other
Member of the Month February for 2 excellent PL/SQL APIs
Member of the Month
05-Mar-2017 11:17:12 by: Juergen Schuster
Juergen Schuster    Other
Newsletter #9 is out!
05-Mar-2017 00:22:18 by: Juergen Schuster

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20