Oracle | DBMS_NOTIFICATIONS

Oracle DBMS_NOTIFICATIONS Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Should be used by DBAs to set, update, and delete notifications in CDB$ROOT.

AUTHID CURRENT_USER

Constants

Name	Data Type	Value
Metadata
version	VARCHAR2(16)	'1'
Notification Types
TYPE_MAINTENANCE	VARCHAR2(32)	'Maintenance'
TYPE_CUSTOMER_ACTION	VARCHAR2(32)	'CustomerAction'
MAINTENANCE_NOTIF Types
EXPECTED_START_DATE	VARCHAR2(32)	'expectedStartDate'
EXPECTED_END_DATE	VARCHAR2(32)	'expectedEndDate'
ACTUAL_START_DATE	VARCHAR2(32)	'actualStartDate'
ACTUAL_END_DATE	VARCHAR2(32)	'actualEndDate'
PRODUCT	VARCHAR2(32)	'product'
STATUS	VARCHAR2(32)	'status'
OP_MODE	VARCHAR2(32)	'operationMode'
CUSTOMER_ACTION	VARCHAR2(32)	'customerAction'
DATABASE_IMPACT	VARCHAR2(32)	'databaseImpact'
DESCRIPTION	VARCHAR2(32)	'description'
PATCH_ID	VARCHAR2(32)	'patchID'
DB_UNIQUE_NAME	VARCHAR2(32)	'dbUniqueName'
DBID	VARCHAR2(32)	'DBID'
ADDITIONAL_DATA	VARCHAR2(32)	'additionalData'
Notification Additional Data Sub-Parameters
INSTANCES	VARCHAR2(32)	'instances'
COMPLETED_INSTANCES	VARCHAR2(32)	'completedInstances'
INPROGRESS_INSTANCES	VARCHAR2(32)	'inProgressInstances'
BATCHES	VARCHAR2(32)	'batches'
COMPLETED_BATCHES	VARCHAR2(32)	'completedBatches'
FROM_VERSION	VARCHAR2(32)	'fromVersion'
TO_VERSION	VARCHAR2(32)	'toVersion'
DRAIN_TIME	VARCHAR2(32)	'drainTime'
PDBS	VARCHAR2(32)	'pdbs'
CON_DBID	VARCHAR2(32)	'con_dbid'
Notification JSON Doc
JSON_DOC	VARCHAR2(32)	'JsonDoc'
Notification UTIL Parameter
DATETIME_FORMAT_DEFAULT	VARCHAR2(32)	'YYYY-MM-DD"T"HH24:MI:SSTZH:TZM'
NOTIF_TYPE	VARCHAR2(32)	'type'
NOTIF_TIME	VARCHAR2(32)	'time'

Dependencies

DBMS_OUTPUT	JSON_KEY_LIST	NOTIFICATIONID
DBMS_SYS_ERROR	JSON_OBJECT_T	NOTIFICATION_SEQ
JSON_ELEMENT_T	NOTIFICATION	PLITBLM

Documented No

First Available 23ai

Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role.

Two new Oracle maintained roles, NOTIFICATIONS_ADMIN and NOTIFICATIONS_USER are used for management.
In addition the MAINTPLAN_APP role is likely relevant to notifications

Source {ORACLE_HOME}/rdbms/admin/dbmsnotifications.sql
{ORACLE_HOME}/rdbms/admin/prvtnotifications.plb

catmaintplanv.sql - creates the MAINTPLAN_APP role.

Subprograms

DELETE_NOTIF	INSERT_NOTIF	UPDATE_NOTIF
GET_NOTIF	INSERT_NOTIF_IMPL

DELETE_NOTIF (new 23ai)

Delete notification based on notification id or notification id with notification as selector dbms_notifications.delete_notif(id IN sys.db$notificationid);

TBD

GET_NOTIF (new 23ai)

Return specific notification record based on notification id or notification id with notification selector

Overload 1 dbms_notifications.get_notif( id IN sys.db$notificationid, notif OUT sys.db$notification);

TBD

Return the cursor of specific notification record based on notification_id

Overload 2 dbms_notifications.get_notif( id IN sys.db$notificationid, notifcursor OUT SYS_REFCURSOR);

TBD

INSERT_NOTIF (new 23ai)

Insert notification with details into the notification table dbms_notifications.insert_notif( notif IN sys.db$notification, id OUT sys.db$notificationid);

TBD

INSERT_NOTIF_IMPL (new 23ai)

Implement inserting a notification with notification_id dbms_notifications.insert_notif_impl( notif IN sys.db$notification, id# IN NUMBER);

TBD

UPDATE_NOTIF (new 23ai)

Update a notification with detail, notification_id cannot be NULL dbms_notifications.update_notif( id IN sys.db$notificationid, notif IN sys.db$notification);

TBD