Blog application built with Oracle Application Express (APEX).
- Oracle database version 19c or later
- Oracle Application Express version 23.2 or later
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 latest version and extract zip archive.
- Access your target APEX workspace
- Select the Application Builder
- Import and install blog-administration-latest.sql and select install supporting objects.
- Import and install blog-public-pages-latest.sql and select install supporting objects.
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
Existing application version must be Release v4.4.20220326 or later.
Before starting the upgrade, backup the application parsing schema data and objects.
- Access your target APEX workspace
- Select the Application Builder
- Import and install blog-administration-latest.sql and select upgrade supporting objects.
- Import and install blog-public-pages-latest.sql and select upgrade supporting objects.
This code is released under MIT license by Jari Laine.