Slack

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 (https://cloud.oracle.com/iaas/products). 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) : https://blogs.oracle.com/oracle-database/oracle-database-18c-xe-now-available
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. https://dsavenko.me/oracledb-apex-ords-tomcat-httpd-centos7-all-in-one-guide-part-two/ 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 https://twitter.com/search?q=orclapex%20compression%20XE&src=typd
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 (https://docs.oracle.com/en/cloud/get-started/subscriptions-cloud/csgsg/oracle-cloud-terminology.html) 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 http://autonumeric.org/
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. https://www.oracle.com/webfolder/technetwork/tutorials/obe/db/apex/r51/translating_appln/translating_appln.html#section4
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? https://docs.oracle.com/cd/B19306_01/server.102/b14195/sqlqr03.htm
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
ReemaPuri
17-Apr-2019 19:49
create a link over region header
Link
1 replies - last reply: 17-Apr-2019 20:27- by: fac586
3648236
17-Apr-2019 19:21
RESTful Data Services - PUT Resource Handler
Link
0 replies
2960970
17-Apr-2019 18:14
Color header of the region
Link
1 replies - last reply: 17-Apr-2019 18:24- by: fac586
dnunknown1
17-Apr-2019 17:54
Side navigation menu spacing
Link
0 replies
user11938659
17-Apr-2019 17:42
Apex 18.2: IG, not able to select more than one row
Link
2 replies - last reply: 18-Apr-2019 00:13- by: John Snyders-Oracle
Rick-Pick
17-Apr-2019 17:22
Dynamic Action triggered by an Interactive Grid Deletion?
Link
1 replies - last reply: 18-Apr-2019 00:26- by: John Snyders-Oracle
Sgodavar-Orac
17-Apr-2019 17:18
How to set the width of the select list
Link
1 replies - last reply: 17-Apr-2019 17:23- by: fac586
SwaroopNashik
17-Apr-2019 15:36
JavaScript and PWA
Link
2 replies - last reply: 17-Apr-2019 21:33- by: fac586
Jason_T
17-Apr-2019 14:38
Interactive Grid Question
Link
1 replies - last reply: 17-Apr-2019 17:07- by: Rick-Pick
user10746787
17-Apr-2019 14:22
Interactive Grid Conditional Color on Select List
Link
0 replies
user2694642
17-Apr-2019 12:26
Create mobile app in apex free online
Link
3 replies - last reply: 18-Apr-2019 00:30- by: Scott Wesley
M-Joveini
17-Apr-2019 11:20
How to install apex 19.1 on pdb and config ORDS 18.4
Link
0 replies
muneer Elmass
17-Apr-2019 09:44
Global APP item
Link
4 replies - last reply: 18-Apr-2019 00:34- by: Scott Wesley
libraking123
17-Apr-2019 08:47
Interactive Grid Default value from Database
Link
0 replies
bveoracle
17-Apr-2019 07:14
How to remove footer (where "1 rows selected" and paging numbers are shown)
Link
0 replies
Sgodavar-Orac
17-Apr-2019 00:44
How to display a page item in the lower right corner
Link
4 replies - last reply: 17-Apr-2019 19:45- by: LA County APEX
Billy~Verreyn
16-Apr-2019 14:04
Saved Interactive Report not saving
Link
0 replies
Kim Mertens
16-Apr-2019 13:55
Cannot set instance parameter HTTP_RESPONSE_HEADERS
Link
2 replies - last reply: 17-Apr-2019 09:17- by: Kim Mertens
Sasha Gomanuk
16-Apr-2019 11:03
APEX 19: Interactive Grid poor Chart customization
Link
8 replies - last reply: 17-Apr-2019 11:38- by: Hilary Farrell-Oracle
Paavo
15-Apr-2019 12:47
Advice how to get p_https_host right in apex_web_service.make_request ?
Link
4 replies - last reply: 17-Apr-2019 08:40- by: Paavo
LMor
15-Apr-2019 10:56
How to define a link from a gantt task ?
Link
1 replies - last reply: 15-Apr-2019 11:38- by: Hilary Farrell-Oracle
Kariman
10-Apr-2019 01:37
Custom error message in execute pl/sql
Link
5 replies - last reply: 17-Apr-2019 16:50- by: Kariman
Nabila Islam
08-Apr-2019 06:31
How to pre-populate Select list data on screen
Link
4 replies - last reply: 17-Apr-2019 23:14- by: Nabila Islam
Laury
02-Apr-2019 15:18
Customizing buttons layout and feel
Link
8 replies - last reply: 17-Apr-2019 19:29- by: Laury
Lee Burgess
25-Jan-2019 10:08
Loading a chart with certain series 'unchecked'.
Link
6 replies - last reply: 17-Apr-2019 12:37- by: SeanRobinson

News

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

Tweets by @orclapexworld

CSS for Home-Pages 1,10,20