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

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

• jcs.disable_trigger

plsqlTopic

onsiteTopic