Re: trigger & snapshot

use the dbms_job package. You can submit any plsql procedure.

Hth,

--
Sybrand Bakker, Oracle DBA
sofresud <sofresud_at_wanadoo.fr> wrote in message news:85k2mk$9u1$1_at_wanadoo.fr...
> Hi,
>
> I would like to execute special pl-sql procedure every day at a special
> time. the way i foud to do that is to create a snapshot that runs at the
> given time , and create a trigger on the table created by the snapshot,
then
> the pl-sql procedure is the trigger body.
> Is there a another way to do a such thing ?? (better way)
>
> Thanks.
>
> Stephane SANDOZ
>
>
>
>
>
>
Received on Thu Jan 13 2000 - 02:34:05 CST