jcs.enable_trigger

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

Summary

  • procedure enable_trigger(tname in varchar2, ttype in integer, tpart in varchar2) (Unsupported)

Add an existing procedure as an enabled trigger.

The trigger type does not have to be specified, in which case the trigger type will be derived from the trigger name. The following trigger types are allowed:

The numeric value constant type
1 const.TRT_BEFORE_DDL BEFORE_DDL
2 const.TRT_ON_DDL ON_DDL
3 const.TRT_ON_EVENT_STATUS_CHANGE ON_EVENT_STATUS_CHANGE
4 const.TRT_ON_JOB_RECALCULATE ON_JOB_RECALCULATE
5 const.TRT_ON_JOB_STATUS_CHANGE ON_JOB_STATUS_CHANGE
6 const.TRT_ON_QUEUE_STATUS_CHANGE ON_QUEUE_STATUS_CHANGE
7 const.TRT_ON_READFILE ON_READFILE
8 const.TRT_ON_SHUTDOWN ON_SHUTDOWN
9 const.TRT_ON_STARTUP ON_STARTUP
10 const.TRT_ON_CONFIRM_MONITOR ON_CONFIRM_MONITOR

Examples

Copy 
An example of how to enable a triggercreate or replace procedure SYSJCS.ON_JOB_RECALCULATE (
          p_job_id     in integer
        , p_new_status in varchar2
        )
        is
        begin
        jcs.operator_message('In Job Recalculate trigger now, for Job ID:'||p_job_id);
        end;
        /

       exec jcs.enable_trigger( 'ON_JOB_RECALCULATE' );

An example of how to enable a trigger

See Also