Re: Autostarting stored procedures

From: Gjlinker <gjlinker_at_aol.com>
Date: 29 Jan 1999 22:22:14 GMT
Message-ID: <19990129172214.22157.00000535@ngol07.aol.com>

Hi,

You can use dbms_job to schedule start a job at specified intervals. To only execute at startup you could write a small script (batch file ?)

Regards, Gerrit-Jan Linker
developer of Oraxcel and OraDebug.
http://members.aol.com/gjlinker

In article <78qh86$rnv$1_at_nnrp1.dejanews.com>, doug_walters_at_my-dejanews.com writes:

>MSSQL Server has a stored procedure titled sp_procoption
>which allows a stored procedure to be run when SQL Serverstarts.
>
>Is there a way I can run a set of SQL commands in a similar
>fashion in Oracle during startup? Thanks.
Received on Fri Jan 29 1999 - 16:22:14 CST