Re: Timer based trigger on the database level
Date: Thu, 16 Nov 2000 20:01:32 GMT
Message-ID: <3A1425DD.F1D530DB_at_home.nl>
No trigger or procedure runs all the time: a trigger runs when triggered by insert, update or delete of data, a procedure runs when called.
From what I understand, you could:
- write a procedure, using dynamic sql (see "based on input from a table")
- queue that, using the dbms_job package to run every x minutes.
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
-- Gtrz, Frank van BortelReceived on Thu Nov 16 2000 - 21:01:32 CET