jcs.raise_event

on-site-related topic PL/SQL API jcs.raise_event

Summary

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

Copy 
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

Copy 
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