APEX Blog
Blog application built with Oracle Application Express (APEX).
Install
System Requirements
- Oracle database version 19c or later
- Oracle Application Express version 24.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 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
- 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.
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
- 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.
License
This code is released under MIT license by Jari Laine.