jcs_odf.drop_event

on-site-related topic PL/SQL API jcs_odf.drop_event

Summary

Drop an event.

Specification

Copy 
procedure drop_event(name in varchar2,
force in varchar2 default const.def_str,
version in number default null,
partition in varchar2 default const.def_str)

Parameters

  • name - the name of the event
  • force - 'Y' or 'N': disregard that the event is still in use
  • version - the version of the event

Note: Note that you cannot delete events that are still in use, unless you use the FORCE clause. When you set the force parameter to 'Y' here, no warning is issued and jobs that are waiting for this particular event immediately start to run.

  • partition - the partition of the event

See Also