Re: newbie: scheduled triggers

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Thu, 04 Feb 1999 21:38:21 +0000
Message-ID: <36BA134D.D164239E@rdbms.freeserve.co.uk>

Beau,

To have Oracle8 run a script periodically use the DBMS_JOB package. To call external procedures check out EXTPROC within Oracle8.

Chris.

Beau Green wrote:
>
> I'm new to Oracle but have taken the first set of PL/SQL classes.
>
> I need my Oracle8 server to run a script every hour. It will open an ODBC
> connection to another type of database server: Forth Shift.
> Reading the foreign database it will create new records in an Oracle8 table.
>
> Where do I create this in Oracle8? It is a trigger? Any key ideals would
> be great; I can read a book from there.
>
> Thanks!
Received on Thu Feb 04 1999 - 15:38:21 CST