Oracle 8i - continuous running procedure
Posted on 2001-07-19
I need to do the following:
Create a stored procedure that will reside in an Oracle 8i database running on Windows 2000. This procedure needs to be running at all times when the database is running. The purpose of the procedure is to execute a query on some SQL Server tables via the SQL Server gateway. (SQL Server 6.5 is also running on Windows 2000). If new records are found in the SQL Server tables, then execute more Oracle procedures/functions. This query needs to be ran every 5 to 10 seconds to check and see if new records exist. If the Oracle database goes down, this procedure needs to be started immediately after the database is available. If the SQL Server connection is lost for any reason, a new connection needs to be created. Any advice on how best to accomplish this task.