Release Date :
6 October 2019

Hosted By :
Bruce Clark

Produced By :

Show Email :
This email address is being protected from spambots. You need JavaScript enabled to view it.

 Donate To APEX Now

 APEX Now is a community podcast, but there are some costs associated with it.  Each week the podcast is uploaded to a media host that distributes the podcast to the various podcast aggregators and maintaining a media host is a cost to the podcast.

If you enjoy APEX Now, please consider a donation toward the podcast costs. Donations are billed in South African Rand )ZAR).

Donate R 150 (currently approx.  $9.98 USD - €9.12 Euro)


Welcome to another episode of APEX Now, the weekly newscast all about Oracle Application Express (APEX). If you are new to the show, this is where you will find all of the latest news, blogs and events as well as some other cool stuff. To listen to some of the past episodes go to

Maybe you are new to APEX. If you are, head on over to where you will find lots of resources to help you. You can evend request a free development environment so you can start working with APEX right away.

The Blogs Of The Week

PL/PDF – Code Reuse
Rodrigo Mesquita

If you are a user of PL/PDF you might follow the practice of creating a unique template for each report you have in an application.

But, this is not the most effecient way. In this post, Rodrigo explains how to write code that you can reuse rather than creating unique templates. An example of how you might use this is to generate report heading. You codewrite the code once, put it in a procedure and call it for each report.

This post is the first in a series of posts that Rodrigo will publish on his experience with PL/PDF.

Custom Authentication and Authorization using built in APEX Access Control - A How To.
Doug Gaul

As you know, application authentication and authorisation is key to its security. Out of the box APEX has a lot to offer with both authentication and authorisation. For instance, you can make use of the Access Control offer by Application Features.

In this post, Doug explains how the standard APEX framework handles Authenication and Authorisation. But, he explains how you may want to enhance this functionality in order to meet spefic requirements. He provides the code for the sample he creates and goes through all of the components required.

The result is a complete scheme that establishes role tiers in a generic and powerful way.

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

This is Dimitri's 10th post in a series of posts on using APEX and other tools on the new Oracle Always Free Cloud Service and Autonomous Transaction Processing.

In an earlier post in the series, Dimitri explained how to set up a virtual machine in a Compute Instance on the Cloud.

Now, here Dimitri helps you to setup SQLcl and Datapump directly on the compute instance in order to have command line tools available to you for automation  and DB interaction. The installation is done on Linux as is the OS of the virtual machine.

Upcoming Events

8 October 2019
Ratingen, Germany
Automated testing with APEX

16 October 2019
APEX Office Hours
Oracle Free Tier and the free Autonomous Database
Guest : Todd Bottger, Director of Product Management for the free Autonomous  Database

16 October 2019APEX  Meetup Group
Frankfurrt, Germany
The Oracle Cloud and APEX

16 - 26 2019
Oracle Groundbreakers Tour

  • Wellington, NZ - October 11
  • Melbourne, Australia - October 14
  • Perth, Australia - October 16
  • Singapore - October 18
  • Shanghai, China - October 19
  • Hangzhou, China - October 20
  • Seoul, South Korea - October 22
  • Tokyo, Japan - October  24     
  • Taiwan - October 26

29-30 October
East Coast Oracle User Group Conference 2019
Raleigh, North Carolina

19 - 22 November 2019
DOAG Conference and Exhibition

1 - 4 December, 2019
UKOUG Techfest 2019
Brighton, United Kingdom

24 April 2020
Maribor, Slovenia!
APEX Alpe Adria
Region APEX Conference
Call for papers is open

05-07 May 2019
Brühl, Germany
APEX Connect 2020

28 June to 2 July 2019
ODTUG Kscope20
Boston, MA, USA


Rapid-Apex APEX Testing Tool.

Rapid-APEX is a tool taht allow you to quickly deploy a test environment of Oracle database, APEX and ORDS in docker. It will be very useful specially when you need a testing APEX environment but different product versions.

Free Oracle Autonomous Database And Web Development With APEX
Caleb Curry

continue text here





Contact Us

Please let us know your name.
Please let us know your email address.
Invalid Input
Please write a subject for your message.
Please let us know your message.
Invalid Input

Contact Us

Our Address

AppLinks (Pty) Limited
20 Wildebees Street
Alberton, South Africa
+27 (0) 11 902 3688
+27 (0) 83 276 3315