This content has been marked as final. Show 6 replies
Additionally, I found this in some Oracle Docs
To create a self-referencing alert:
You create a self-referencing alert the same way you would create any other alert, but
you tailor your alert Select statement by adding to the Where clause a comparison
between the values in the implicit input :DATE_LAST_CHECKED and the column that
contains the date and time information that you want your alert to reference.
Suppose your Select statement contains the following lines:
AND creation_date > TO_DATE(:DATE_LAST_CHECKED,
In this example, Oracle Alert compares the date and time information in the column
CREATION_DATE with the date and time information in :DATE_LAST_CHECKED to
determine which exceptions are new.
However, my alert cannot be 'verified' or 'run' when I use the above statement, even after changing to
WHERE TO_DATE(SYSDATE, 'DD-MON-YYYY HH24:MI:SS') > TO_DATE(:DATE_LAST_CHECKED,'DD-MON-YYYY HH24:MI:SS')