[Home] [Help]
485: '_' || EVENT_MODE || 'AR';
486:
487: SELECT table_name
488: INTO v_table_name
489: FROM user_triggers
490: WHERE trigger_name = v_trigger_name_orig;
491:
492: -- check whether a new trigger must be created or not
493: if (v_table_name = TBL_NAME) then
495: else
496: TRIGGER_NAME := v_trigger_name;
497: end if;
498:
499: -- exception handling for select ... from user_triggers
500: exception
501: when no_data_found then -- trigger does not exist
502: TRIGGER_NAME := v_trigger_name;
503: end GET_TRIGGER_NAME;