Very interesting, the error only happens when I try to replace an application. If I create a new one the import works fine.
17-Apr-2019 10:06:AM by: Florian H.
Hi everyone, I get this error message while trying to import an application from development to quality system, any idea what could be the problem? This happens after upgrading to 19.1
17-Apr-2019 07:35:AM by: Florian H.
These days, I'd say go with the IaaS offerings ( There's a learning curve and it isn't cheap, but you'll get all the control you need. Roel did mention that you can also get a compute instance for about US$25 monthly that you can put your APEX stack on. There are of course "cheaper" options to host XE, but there are advantages to using OCI if your plan is to eventually expand to a "full license". For multitenant options, you'll need to rent the "Enterprise Edition High Performance" that costs upwards of $1238/month, but you'll probably spend enough that qualifies you for discounts if you went with Monthly Flex pricing.
16-Apr-2019 10:35:PM by: fuzziebrain
for each record
16-Apr-2019 07:30:PM by: gopalakrishna
Do you want to print success/fail with each submitted record? or for the entire body submitted?
16-Apr-2019 07:29:PM by: Alan Quigley
Hi Everyone, Please help how to print multiple response in json body ? Example: response={success={your record successfully submitted}, failure={your record failed to submit}}
16-Apr-2019 05:31:PM by: gopalakrishna
Yay, thanks again both!
16-Apr-2019 01:52:PM by: j4john
Correction : XE18C does support partitioning (and a lot more) :
16-Apr-2019 01:42:PM by: roelhartman
Thanks ade_bds, that's good to have in the kitbag. Sadly, XE doesn't support partitioning, which will be needed in the production deployment of the system I'm working on, so I'll have to look at another route
16-Apr-2019 01:36:PM by: j4john
Hi @j4john, you may find this link useful. You can create an XE18c / APEX 19.1 environment for $10/month with 3 PDBs and sys as sysdba control. Apparently 18c XE can actually be expanded close to 40G with advanced compression
16-Apr-2019 01:06:PM by: ade_bds
Thanks Roel, that's really useful information. Just wish Oracle Corp would make these things simpler to understand and navigate. The technology - Apex and the Database - is, as we know and love, wonderful. In the Cloud offerings it's just so damn hard to engage with! Love your blogs by the way - always interesting and helpful. Yet again I learn from you, so thanks.
15-Apr-2019 10:35:PM by: j4john
And yes, it is complicated :wink:
15-Apr-2019 08:39:PM by: roelhartman
If XE is large enough for you you can do all that magic with XE 18c on Oracle’s OCI for less than $50 / month - but you do have to configure everything yourself. If you want a DB service and bring your DB license it’s about $350 for Standard and $650 for Enterprise Edition (but I think that’s even without multitenant - thus no PDB’s).
15-Apr-2019 08:38:PM by: roelhartman
As PDB_ADMIN you can grant CREATE ANY CONTEXT As PDB_ADMIN you can create PUBLIC SYNONYMS and GRANT other users to do so. PDB_ADMIN is your “SYS” user, the one with the highest privileges . And as your EECS instance is just a PDB (one PDB) it is completely logical you can’t do PDB operations. If you need to do that, you need a “real” database and is (one) EECS too lightweight for your purposes. (disclaimer: I’m not an Oracle employee)
15-Apr-2019 08:27:PM by: roelhartman
Hi folks, I'm trying to do some development on an Oracle Cloud Exadata Express instance, but running into some limitations. I'd like to use Logger, as in the apps I develop elsewhere, but Logger needs CREATE ANY CONTEXT privilege, which OCEE doesn't allow. My apps also tend to use different schemas, but although OCEE lets me create multiple schemas it doesn't allow me to create public synonyms. OCEE has some significant limitations: no access to SYS or SYSTEM, no PDB operations (I'd like to be able to use different PDBs for dev, test, prod...), no Data Pump and so on. Could anyone (from Oracle?) advise on how to navigate the rather opaque Oracle Cloud offerings ( to obtain cost-effective development and production environments that don't have these limitations? Is there a simple How-To guide anywhere? Thanks.
15-Apr-2019 08:00:PM by: j4john
Hi, could a Vscode regular user tell me what to do to connect to oracle database? :wink:
15-Apr-2019 02:54:PM by: Souleman
HI All, Requirement Type: Interactive Grid I have to add new column in interactive grid when I clicking the new added button. How can I achieve this..Is there any demo applications for this.?? I could able to do this by using classic report but I need to do using IG. Thank you...
14-Apr-2019 10:25:AM by: arjun
@Shane Bentz Thanks for your Reply. It s possible some with DA. But the feature of automated row fetch is most effective (Like Oracle forms Execute Query Trigger) and may enhance the apex forms feature
13-Apr-2019 01:53:PM by: k_islam
@krisrice awesome, thanks :slightly_smiling_face: ``` #INFO Number of rows processed: 65 #INFO Number of rows in error: 0 0 - SUCCESS: Load processed without errors ```
11-Apr-2019 10:23:PM by: Alex_86
Include the library in your page or in your application The you will need to initialize the plugin for the items you need Have a look at the website for examples
11-Apr-2019 09:20:PM by: maxime_tremblay
how do I incorporate it with the page item?
11-Apr-2019 08:42:PM by: abul_feed
if this is via the auto-rest, there is a CSV bulk load rest end point
11-Apr-2019 08:41:PM by: krisrice
you'd have to write custom plsql to process and do the inserts
11-Apr-2019 08:41:PM by: krisrice
``` curl -H"Content-Type:application/json" \ -X POST \ -d'{"empno":4711,"ename":"APEX","job":"DEV","hiredate":"2001-01-01T20:00:00Z","sal":10,"comm":null,"deptno":10,"mgr":7839}' \ http://localhost:28080/ords/testit/emp/ ``` ...will send an row via REST-API into the emp-table, is it possible to write more then one record in the table? ``` curl -H"Content-Type:application/json" \ -X POST \ -d'[{"empno":4765,"ename":"FIRSTENTRY","job":"HARTZ4","hiredate":"2001-01-01T20:00:00Z","sal":10,"comm":null,"deptno":10,"mgr":7839},{"empno":4711,"ename":"SECONDENTRY","job":"DEV","hiredate":"2001-01-01T20:00:00Z","sal":10,"comm":null,"deptno":10,"mgr":7839}]' \ http://localhost:28080/ords/testit/emp/ ``` wont work.. any hints?
11-Apr-2019 08:39:PM by: Alex_86
Thank you!!!
11-Apr-2019 08:21:PM by: abul_feed
Then autonumeric will work :wink:
11-Apr-2019 08:19:PM by: maxime_tremblay
@maxime_tremblay when typing
11-Apr-2019 08:04:PM by: abul_feed
I like to use this
11-Apr-2019 07:51:PM by: maxime_tremblay
While typing or when submitting?
11-Apr-2019 07:48:PM by: maxime_tremblay
Hello all. what's the best way to allow only numbers in a text or number page item?
11-Apr-2019 07:47:PM by: abul_feed
How can I translate an Oracle APEX application in its 19 version? Is it much different from what already existed in previous versions? Not urgent but it's important for me to learn.
11-Apr-2019 03:58:PM by: Franklin
And it also answers my first question - I didn't notice the difference between SQL query and SQL expression! Sounds silly but I always failed to catch it. Thanks again.
11-Apr-2019 02:54:PM by: Franklin
Another great day to learn new things. Thanks :slightly_smiling_face:
11-Apr-2019 02:39:PM by: Franklin
I guess this is what you're talking about, right?
11-Apr-2019 02:35:PM by: Franklin
Goof catch @maxime_tremblay… didn’t spot that!
11-Apr-2019 02:29:PM by: roelhartman
You have a sql query and the source is expecting a sql *expression*
11-Apr-2019 02:24:PM by: maxime_tremblay
try remove the ;
11-Apr-2019 02:22:PM by: roelhartman
What am I doing wrong here? Fields and table do exist.
11-Apr-2019 02:14:PM by: Franklin
If I'm understanding your question, doing something like that after the page is already loaded typically involves using a dynamic action to retrieve the data and populate the items on the page. Doing that would not use the "automated row fetch" mechanism built into APEX that typically is run on page load. If you used a dynamic action to retrieve that information, you just need some triggering event to initiate it, like clicking a button or a link or something.
11-Apr-2019 02:04:PM by: Shane Bentz

APEX Forum

Here you find the 25 latest APEX Forum Threads updated every 5 Minutes
19-Apr-2019 02:18
Failed to Execute Delete
1 replies - last reply: 19-Apr-2019 02:18- by: W.Lionel
18-Apr-2019 23:42
How to display report created in report builder
1 replies - last reply: 19-Apr-2019 00:17- by: user1.0
Guangyu Mao
18-Apr-2019 22:43
The delete data on the table still appear on the text field.
1 replies - last reply: 18-Apr-2019 22:46- by: Guangyu Mao
18-Apr-2019 20:25
How to use APEX_WEB_SERVICE.make_rest_request ?
1 replies - last reply: 19-Apr-2019 09:00- by: Pavel_p
18-Apr-2019 18:33
JS code - Best practice
1 replies - last reply: 18-Apr-2019 18:33- by: partlycloudy
18-Apr-2019 17:37
Apex 18.2 IG select list column not refreshing BUG
0 replies
18-Apr-2019 17:27
Select list: need to allow free form input in addition
0 replies
18-Apr-2019 16:10
APEX 5.1 interactive grid select all row selection across pages
0 replies
18-Apr-2019 15:33
Apex 19, classic report: how to apply row filters ?
2 replies - last reply: 18-Apr-2019 16:52- by: rajk5
18-Apr-2019 13:52
Is there a way to hide the 'Right Side Column' programatically?
0 replies
18-Apr-2019 13:11
Issue in update collection
6 replies - last reply: 19-Apr-2019 08:15- by: Sek1491
18-Apr-2019 05:23
apex not working after server restart
6 replies - last reply: 18-Apr-2019 10:43- by: Billy~Verreynne
18-Apr-2019 04:27
Apex 19.1: Create a Form as a master and an IG as a detail region (save boton)
1 replies - last reply: 18-Apr-2019 05:45- by: Franck N
18-Apr-2019 02:32
How to use the function in $("#rds")
4 replies - last reply: 19-Apr-2019 05:54- by: shinotomo000401
17-Apr-2019 19:49
create a link over region header
1 replies - last reply: 17-Apr-2019 20:27- by: fac586
17-Apr-2019 17:22
Dynamic Action triggered by an Interactive Grid Deletion?
2 replies - last reply: 18-Apr-2019 11:37- by: Rick-Pick
17-Apr-2019 15:36
JavaScript and PWA
4 replies - last reply: 18-Apr-2019 14:21- by: InoL
17-Apr-2019 12:26
Create mobile app in apex free online
5 replies - last reply: 18-Apr-2019 12:37- by: Ora_Learner890
muneer Elmass
17-Apr-2019 09:44
Global APP item
4 replies - last reply: 18-Apr-2019 00:34- by: Scott Wesley
16-Apr-2019 14:28
Internal error when using apex_authentication.logout
1 replies - last reply: 19-Apr-2019 08:15- by: Chipniz
16-Apr-2019 14:04
Saved Interactive Report not saving
0 replies
Sasha Gomanuk
16-Apr-2019 11:03
APEX 19: Interactive Grid poor Chart customization
9 replies - last reply: 18-Apr-2019 11:41- by: Hilary Farrell-Oracle
15-Apr-2019 12:47
Advice how to get p_https_host right in apex_web_service.make_request ?
5 replies - last reply: 19-Apr-2019 09:14- by: Pavel_p
10-Apr-2019 01:37
Custom error message in execute pl/sql
5 replies - last reply: 18-Apr-2019 15:26- by: Kariman
20-Jan-2019 16:16
Tab Key control on an Interactive Grid
1 replies - last reply: - by:


Bartosz Ostrowski    Other
New Podcast: Przemyslawi and Bartosz from Pretius, Second Line of Defense
17-Apr-2019 12:17:19 by: Juergen Schuster
JMJ Cloud Austin  
The new Email Template
18-Apr-2019 15:41:45 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: UK, Edinburgh, permanent
17-Apr-2019 07:28:08 by: Juergen Schuster
Shakeeb Rahman    Other
Video: Building a complete App in 30 minutes
Applications, Videos
16-Apr-2019 21:08:32 by: Juergen Schuster
Rodrigo Mesquita  
Secure your Application
16-Apr-2019 13:14:48 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: Spain, Barcelona, Part-time
12-Apr-2019 09:12:53 by: Juergen Schuster
mike hichwa    Other
Video: Live Q&A recording from APEX Alpe Adria
Conferences, Videos
11-Apr-2019 19:00:38 by: Juergen Schuster
mike hichwa    Other
Live Streaming "Ask Mike Hichwa" from APEX Alpe Adria, April 11, 12 ET NOON, Ask Questions Live!
26-Mar-2019 15:05:40 by: Juergen Schuster
Juergen Schuster    Other
Newsletter #34 is out!
10-Apr-2019 19:45:53 by: Juergen Schuster
Sylvain Martel  
Extending EBS Part 3
09-Apr-2019 19:04:34 by: Juergen Schuster
Jeffrey Kemp  
The Escape Thing
Dynamic Actions, Security
08-Apr-2019 11:25:40 by: Juergen Schuster
Bartosz Ostrowski    
New Plug-in: Everything you ever wanted from a LOV
LOVs, Plug-ins
08-Apr-2019 08:13:44 by: Juergen Schuster
Adam Kierzkowski    
New Plug-in: Flexible Regions
08-Apr-2019 06:34:19 by: Juergen Schuster
Rodrigo Mesquita    
New Plug-in: Create multiple form items dynamically
Form (APEX), Plug-ins
08-Apr-2019 06:20:11 by: Juergen Schuster
Zoran Tica    
New Plug-in: QR-Code
08-Apr-2019 06:15:21 by: Juergen Schuster
Juergen Schuster  Other
CDN for 19.1 is out
07-Apr-2019 16:20:04 by: Juergen Schuster
Anton Scheffer    Other
New Plug-in: The famous Excel to APEX
Excel, Plug-ins
07-Apr-2019 10:14:55 by: Juergen Schuster
Michelle Skamene  Other
Dynamic Wizard Navigation
PL/SQL, Workflow
05-Apr-2019 15:29:15 by: Maxime Tremblay
Jackie Mcilroy    Other
New Podcast: Don't Ask Me I'm Just a Woman! #LowHighPodcast
04-Apr-2019 16:37:28 by: Jackie Mcilroy
Joel Kallman  
Deploy APEX on Oracle Cloud Infrastructure Database with Terraform
03-Apr-2019 13:14:03 by: Juergen Schuster
Juergen Schuster  Other
New Job Offer: India, Tamil Nadu, Chennai, permanent
03-Apr-2019 08:27:43 by: Juergen Schuster
David Anderson    Other
Multiple Live Web-Class Trainings different Topics
03-Apr-2019 06:44:26 by: Juergen Schuster
Jeffrey Kemp    
The new Forms Region in 19.1
APEX 19, Form (APEX)
03-Apr-2019 06:38:07 by: Juergen Schuster
David Peake  Other
White paper - Extending EBS with APEX
03-Apr-2019 01:51:53 by: Jackie Mcilroy
Dan McGhan    Other
New Training - Onsite, Utrecht, Netherlands, Getting started with JavaScript for PL/SQL & APEX Developers
02-Apr-2019 01:05:27 by: Jackie Mcilroy
Denes Kubicek  Other
Experience problems with CSS after 19.1
APEX 19, Bugs
01-Apr-2019 18:06:52 by: Juergen Schuster
Jackie Mcilroy    Other
Live #LowHighPodcast April 2nd, 12 ET
28-Mar-2019 13:21:46 by: Jackie Mcilroy
Ronny Weiß    Other
Member of the Month, March: For another 2 nice Plug-ins and his past contribution
Member of the Month
01-Apr-2019 14:05:50 by: Maxime Tremblay
Scott Wesley  
Setting a reasonable Max Webservice Requests setting
Installation, REST
31-Mar-2019 18:40:56 by: Juergen Schuster
Scott Wesley  
Hide Pagination if one page results
Reports, jQuery
31-Mar-2019 02:52:18 by: Maxime Tremblay
John Snyders  
IG Cookbook Update for 19.1
APEX 19, Grid
31-Mar-2019 02:48:32 by: Maxime Tremblay
Dimitri Gielis  
When is a good time to upgrade?
30-Mar-2019 11:57:48 by: Juergen Schuster

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20