Re: Timer based trigger on the database level

Use the dbms_job package.

Milan Olsen wrote:

> Hello
>
> I want make a trigger or procedure that runs all the time, and evry now and
> then (based on the time setting in the trigger or procedure) selects a query
> based on the input from a table.
>
> Question:
>
> How do a make something time triggered on an Oracle 8.1.6.0.0 Enterprise
> Edition server.
>
> Note: I need a something on the database level, not application wise (like
> in Dev 6i, where there are some timer based functionalities).
>
> YF

--
Brett England         | brett_at_recalldesign.com   | www.recalldesign.com
Information Architect | Direct: +61 8 8217 0562  | Mobile: 040 858 1102
Recall Design Pty Ltd | Tel:    +61 8 8217 0500  | Fax: +61 8 8217 0555
                      | 53 Gilbert Street, Adelaide SA 5000,  AUSTRALIA