Re: How can I create a trigger that depends on system date?

I think you should take a look at dbms_job package. Creating a trigger on a dictionary object is not allowed. For example : creating a trigger on a system-date-field-update (if it exists) would block the system-date-field-update if the trigger fails.

Rob

dj_brun_at_my-deja.com heeft geschreven in bericht <832kjs$uv0$1_at_nnrp1.deja.com>...
>I donīt know if there's any way to create a
>trigger that depends on system date. I want
>Oracle to fire the trigger when the day of the
>current system date= 1. If someone could tell
>me...
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Mon Dec 13 1999 - 06:59:04 CST