DBA Data[Home] [Help]

HR.DR$IRC_SEARCH_CRITERIA_CTXTC dependencies on DRVDML

Line 1: trigger "HR"."DR$IRC_SEARCH_CRITERIA_CTXTC" after insert or update on "HR"."IRC_SEARCH_CRITERIA" for each row 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;

1: trigger "HR"."DR$IRC_SEARCH_CRITERIA_CTXTC" after insert or update on "HR"."IRC_SEARCH_CRITERIA" for each row 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;