OR 11.2 | Create Dbevent Statement

Language Reference Guide > Language Reference Guide > Statements > OpenROAD SQL Statements > Create Dbevent Statement

Was this helpful?

Create Dbevent Statement

The create dbevent statement defines a database event.

This statement has the following syntax:

create dbevent [schema.]event_name;

The create dbevent statement creates the specified database event. Database events enable an application to pass status information to other applications.

Database events can be registered or raised by any session, provided that the owner has granted the required permission (raise or register) to the session's user, group, or role identifier, or to public. Only the user, group, or role that created a database event can drop that database event.

Parameters--Create Dbevent Statement

This statement has the following parameter:

event_name

Identifies the event. The event_name must be a valid object name.

Permissions: All Users

This statement is available to all users.

Create Dbevent Locking

The create dbevent statement locks pages in the iievent catalog.

Create Dbevent Related Statements

Drop Dbevent Statement

Grant (privilege) Statement

Raise Dbevent Statement

Last modified date: 12/20/2023