jcs.clear_event

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

Summary

Clear an event, so that it can be raised again.

Privileges

you need the CLEAR_EVENT system privilege

Specification

Copy 
procedure clear_event(event_name in varchar2,
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
  • 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 clear_event(event_name in varchar2,
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
  • 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