Re: Timed Triggers

From: Stephen Bell <stephen.bell_at_cgi.ca>
Date: Thu, 9 Aug 2001 09:05:03 -0400
Message-ID: <qSvc7.39350$5c.2864482@news20.bellglobal.com>

Hi Bob,

I think the DBMS_JOB package will provide what you need.

Hope it helps,
Steve

"Bob Brothers" <rbrothers_at_tqtx.com> wrote in message news:6e230b8f.0108090439.35b56d83_at_posting.google.com...
> I'm setting up a Oracle 8 database that contains usernames and an
> expiration date for each user. Access to the corporate outside web
> page needs to be disabled for the concerned individual after the
> expiration date is passed.
>
> I know I can use a cron, or other external timed event to handle this,
> but is there any way (timer trigger?) inside of Oracle (not forms or
> graphics) that this can be done?
>
> TIA
> Bob Brothers
Received on Thu Aug 09 2001 - 08:05:03 CDT