You can write your own scripts and using DBMS_PKGS you can have notification