PL/SQL API jcs.raise_event · Redwood Documentation

Summary

procedure raise_event(event_name in varchar2, message_text in varchar2, can_commit in boolean, do_commit in boolean, event_partition in varchar2)
procedure raise_event(event_name in varchar2, message_text in varchar2, can_commit in varchar2, do_commit in varchar2, event_partition in varchar2)

Raise an event, releasing all jobs that are waiting for this event.

All jobs that are in status EVENTWAIT and refer to this event are set to have satisfied this event. If they have no more events to wait for, they continue.

Privileges

you need the RAISE_EVENT system privilege

Specification

procedure raise_event(event_name in varchar2,
message_text in varchar2 default null,
can_commit in boolean default false,
do_commit in boolean default true,
event_partition in varchar2 default null)

This version allows the can_commit and do_commit parameters to be true or false.

Parameters

event_name - name of the event
message_text - comment that will be logged with the event and the jobs
can_commit -
if true, and do_commit is also true, commit the current transaction
if false, and do_commit is true, commit using an autonomous transaction
do_commit -
if true, commit in accordance with the can_commit parameter
if false, do not commit. Caller is responsible for committing, or rolling back.
event_partition - partition of the event If it is not filled in the default partition is assumed

Transaction keyword

The transaction keyword defines how and/or when the changes are committed to the database. A definition of the various transaction keywords can be found on the jcs package summary page.

can_commit_autonomous

Specification

procedure raise_event(event_name in varchar2,
message_text in varchar2 default null,
can_commit in varchar2,
do_commit in varchar2 default const.jcs_yes,
event_partition in varchar2 default null)

This version allows the can_commit and do_commit parameters to be 'Y' or 'N'.

Parameters

event_name - name of the event
message_text - comment that will be logged with the event and the jobs
can_commit -
if true, and do_commit is also true, commit the current transaction
if false, and do_commit is true, commit using an autonomous transaction
do_commit -
if true, commit in accordance with the can_commit parameter
if false, do not commit. Caller is responsible for committing, or rolling back.
event_partition - partition of the event If it is not filled in the default partition is assumed

plsqlTopic

onsiteTopic