TRIGGER: HR.DR$IRC_SEARCH_CRITERIA_CTXTC

Source

Description

"HR"."DR$IRC_SEARCH_CRITERIA_CTXTC" after insert or update on "HR"."IRC_SEARCH_CRITERIA" for each row 

Type

AFTER EACH ROW

Event

INSERT OR UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

declare   reindex boolean := FALSE;   updop   boolean := FALSE; begin   ctxsys.drvdml.c_updtab.delete;   ctxsys.drvdml.c_numtab.delete;   ctxsys.drvdml.c_vctab.delete;   ctxsys.drvdml.c_rowid := :new.rowid;   if (inserting or updating('KEYWORDS')) then     reindex := TRUE;     updop := (not inserting);     ctxsys.drvdml.c_text_vc2 := :new."KEYWORDS";   end if;   ctxsys.drvdml.ctxcat_dml('HR','IRC_SEARCH_CRITERIA_CTX', reindex, updop); end;