ā·pěks 10 Years Later

Uncategorized
| Nov 12, 2019


Exactly 10 years ago today, I wrote a succinct blog post with the intent of clarifying how to properly pronounce and abbreviate Oracle APEX.  I decided to use the phonetic spelling, ā'pěks, to avoid all ambiguity with the pronunciation.  Was I successful?

  • I still encounter many people who spell this Apex (and not the correct APEX)
  • I routinely hear people pronounce this as ah·pěks or ap·ěks (and not the correct ā'pěks)

Obviously, we still have (more...)

Free Oracle Cloud: 15. The request could not be mapped to any database

Uncategorized
| Nov 6, 2019
This post is the last post of a series of blog posts on the Best and Cheapest Oracle APEX hosting: Free Oracle Cloud.

At some point you might face the following message: "The request could not be mapped to any database":


Oracle is monitoring usage on your Always Free Account and whenever it finds there's no activity for 7 days, it will stop your database automatically. It will preserve the data in the database, but (more...)

My Personal Thanks to the Chicago Police Department – the First Real Proving Ground for Oracle APEX

Uncategorized
| Nov 2, 2019

In 2001, the Chicago Police Department took a chance on APEX.  And with all thanks to them for the opportunity they provided us, Oracle APEX is what it is today.  We owe them a big debt of gratitude.  Let me explain.

As many people know, the genesis of Oracle APEX was an internal development project that began in 1999, to build a Web-based HTML calendar for use by Oracle employees.  My (more...)

How to Script Workspace Provisioning on Oracle Autonomous Database

Uncategorized
| Oct 29, 2019
I have moved my blogging over to blogs.oracle.com/apex. See my latest post here.

Native Oracle DB JSON functionality as alternative for using cursor() in AOP (and APEX_JSON)

Uncategorized
| Oct 27, 2019
When using external (WEB/REST) services, you often communicate in JSON. So it's important to be able to generate JSON in the format that is expected by the external service.

In the case of APEX Office Print (AOP), we made it super simple to communicate with the AOP server from the database through our PL/SQL API. You just have to enter a SQL statement and the AOP PL/SQL API, which uses APEX_JSON behind the scenes, (more...)

Free Oracle Cloud: 14. Your Oracle Cloud Free Trial has expired (but FREE still running)

Uncategorized
| Oct 17, 2019
This post is the last post of a series of blog posts on the Best and Cheapest Oracle APEX hosting: Free Oracle Cloud.

Today I got an email that my Oracle Cloud account was Expired. While I have an Always FREE Oracle Cloud, when I signed up I also got some extra credits that lasted for a month. Those credits are no longer valid.


When you log in to your Oracle Cloud Dashboard you will (more...)

OGB Appreciation Day: add an error in a PL/SQL Process to the inline notification in Oracle APEX

Uncategorized
| Oct 10, 2019
This post is part of the OGB (Oracle Groundbreakers) Appreciation Day 2019, a thank you to everyone that makes the community great, especially those people that work at keeping us all moving!

Before I give my tip on how to add an error message from your PL/SQL code in your Page Process to a notification message in Oracle APEX, I want to start with thanking some people.

What keeps me going are a few things:

Free Oracle Cloud: 13. Final things to take away

Uncategorized
| Oct 10, 2019
This post is the last post of a series of blog posts on the Best and Cheapest Oracle APEX hosting: Free Oracle Cloud.

By now we have seen how you can set up the different components from the Always Free Oracle Cloud.

During Oracle Open World I talked to the people behind the Always Free Oracle Cloud, and they told me that when your account is inactive for a specified amount of time (I forgot (more...)

Free Oracle Cloud: 12. Create a 2nd Compute Instance and a Load Balancer

Uncategorized
| Oct 4, 2019
This post is part of a series of blog posts on the Best and Cheapest Oracle APEX hosting: Free Oracle Cloud.

In my blog post Create a VM Instance (Compute Cloud) we created a VM instance in the Free Oracle Cloud. The cool thing is that you get two VMs for free. In this post, we will set up the other always free compute instance.

Just like when we created our first instance, hit the (more...)

Free Oracle Cloud: 11. Sending Emails with APEX_MAIL on ATP

Uncategorized
| Oct 4, 2019
This post is part of a series of blog posts on the Best and Cheapest Oracle APEX hosting: Free Oracle Cloud.

In this post, we will configure the Oracle Cloud to support our instances, databases and Oracle APEX to send out emails. In my blog post 5. Setup APEX in ATP and create first APEX app, I initially said you can't use APEX_MAIL in APEX in ATP, but I was wrong, so I few days (more...)

Free Oracle Cloud: 10. Running SQLcl and Datapump from the Compute Instance (VM) to ATP

Uncategorized
| Oct 1, 2019
This post is part of a series of blog posts on the Best and Cheapest Oracle APEX hosting: Free Oracle Cloud.

In this post, we will install and use SQLcl and Datapump from the Compute Instance (VM) connecting to our Oracle Database in the Autonomous Transaction Processing (ATP) Cloud.
Although I use most of the time SQL Developer to connect to the database, I find it important to be able to use command-line tools too, (more...)

Extending Oracle APEX – live event in Vienna

Uncategorized
| Sep 30, 2019

Quick Note: this Friday, October 4th 2019, will be a morning event about extending Oracle APEX with Single Page Applications, Master-Detail, and Drag&Drop. In Vienna at the Oracle office.

Check out the event details and sign up!

AOP Introduction in Vienna

Uncategorized
| Sep 30, 2019

Reserve a free spot in our AOP Introduction training, on November 8th 2019 in Vienna/Austria.

We invited Sunil Tandan from the APEX Office Print Team, to give a halfday intro training to everyone who is interested (and fits the room).

If you are in the area you should definitely book this.

Free Oracle Cloud: 9. Setup Object Storage and use for File Share and Backups

Uncategorized
| Sep 28, 2019
This post is part of a series of blog posts on the Best and Cheapest Oracle APEX hosting: Free Oracle Cloud.

In this post, we will look into how we can store and share files, with ourselves, with others, but also with our ATP Database, we set up earlier. The Oracle Cloud provides for this purpose Object Storage, and we get 20GB for free forever. This storage is also being used when you want to make backups (more...)

Free Oracle Cloud: 8. Setup APEX Office Print (AOP) to export to PDF, Excel, Word, Powerpoint, HTML and Text

Uncategorized
| Sep 25, 2019
This post is part of a series of blog posts on the Best and Cheapest Oracle APEX hosting: Free Oracle Cloud.

In the previous posts we setup our Always Free Oracle Cloud machine and an Autonomous Database with Oracle Application Express (APEX). In this post I want to show you how to get started with the popular printing and reporting engine, APEX Office Print (AOP). The AOP software makes it super easy to export your (more...)

Free Oracle Cloud: 7. Setup a web server on the Virtual Machine

Uncategorized
| Sep 22, 2019
This post is part of a series of blog posts on the Best and Cheapest Oracle APEX hosting: Free Oracle Cloud.

In this blog post we will configure a web server on our Compute VM Instance. This allows us to host some websites and have a custom URL for our Oracle APEX instance and applications.

Lets start with connecting to our VM:

From a Terminal connect to your Oracle Cloud VM:

ssh -i ssh_key opc@public_ip

(more...)

Free Oracle Cloud: 6. Create a VM Instance (Compute Cloud)

Uncategorized
| Sep 20, 2019
This post is part of a series of blog posts on the Best and Cheapest Oracle APEX hosting: Free Oracle Cloud.

In this post we will setup a virtual machine with Oracle Linux. If you need a machine in the Cloud, this service is for you... and you can't beat the price, it's FREE!

So why would you need a machine in the Cloud? For anything that you do on your own machine, you can (more...)

Free Oracle Cloud: 5. Setup APEX in ATP and create first APEX app

Uncategorized
| Sep 19, 2019
This post is part of a series of blog posts on the Best and Cheapest Oracle APEX hosting: Free Oracle Cloud.

Login to your Oracle Cloud Account. Once in, navigate on the left hamburger icon to Autonomous Transaction Processing and select the Autonomous Database. In the overview screen click the Service Console:


Make sure you allow pop-ups as it opens a new tab.
You will get a graphical overview, in here you want to click (more...)

Free Oracle Cloud: 4. Connecting with SQL Developer Web to ATP

Uncategorized
| Sep 18, 2019
This post is part of a series of blog posts on the Best and Cheapest Oracle APEX hosting: Free Oracle Cloud.

Login to your Oracle Cloud Account. Once in, navigate on the left hamburger icon to Autonomous Transaction Processing and select the Autonomous Database. In the overview screen click the Service Console:


Make sure you allow pop-ups as it opens a new tab.
You will get a graphical overview, in here you want to click (more...)

Free Oracle Cloud: 3. Connecting with SQL Developer (Desktop) to ATP

Uncategorized
| Sep 17, 2019
This post is part of a series of blog posts on the Best and Cheapest Oracle APEX hosting: Free Oracle Cloud.

In the previous post we setup our Oracle database in the Free Autonomous Oracle Database Cloud.
Now we want to connect to this database from our machine with SQL Developer.

Login to your Oracle Cloud Account. In case you forgot the link, you can always go back to your emails and in the "Your (more...)