APEX Blog

Blog application built with Oracle Application Express (APEX).

Install

System Requirements

• Oracle database version 19c or later
• Oracle Application Express version 22.1 or later

Needed Privileges

Ensure target schema associated to your APEX workspace has following system privileges and roles:

• CREATE INDEXTYPE
• CREATE PROCEDURE
• CREATE SEQUENCE
• CREATE TYPE
• CREATE TABLE
• CREATE TRIGGER
• CREATE VIEW
• CREATE JOB
• CTXAPP

APEX workspace administrator privileges are required to create a user group for authorization.

Import Applications

1. Access your target APEX workspace
2. Select the Application Builder
3. Import and install blog_administration.sql and select install supporting objects.
4. Import and install blog_public_pages.sql and select install supporting objects.

Post Install

Create a "Bloggers" workspace user group. Add APEX users to the group who are authorized to use the blog admin application. See Using Groups to Manage Application Express Users

Upgrade

Existing application version must be Release v4.4.20220326 or later.

Before starting the upgrade, backup the application parsing schema data and objects.

Import Applications

1. Access your target APEX workspace
2. Select the Application Builder
3. Import and install blog_administration.sql and select upgrade supporting objects.
4. Import and install blog_public_pages.sql and select upgrade supporting objects.

License

This code is released under MIT license by Jari Laine.