APEX Blog

Blog application built with Oracle Application Express (APEX).

Install

System Requirements

• Oracle database version 19c or later
• Oracle Application Express version 23.2 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 TABLE
• CREATE TRIGGER
• CREATE VIEW
• CTXAPP

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

Download

Download latest version and extract zip archive.

Import Applications

1. Access your target APEX workspace
2. Select the Application Builder
3. Import and install blog-administration-latest.sql and select install supporting objects.
4. Import and install blog-public-pages-latest.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 v22.2.1.20230117 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-latest.sql and select upgrade supporting objects.
4. Import and install blog-public-pages-latest.sql and select upgrade supporting objects.

License

This code is released under MIT license by Jari Laine.