Xref: alice comp.databases.oracle.server:39561 Path: alice!news-feed.fnsi.net!netnews.com!howland.erols.net!peer-feed.news.demon.net.MISMATCH!woodstock.news.demon.net!demon!news.demon.co.uk!demon!camk.demon.co.uk!Andy.Hardy From: Andy Hardy Newsgroups: comp.databases.oracle.server Subject: Re: How to run a stored procedure once at db start Date: Tue, 2 Feb 1999 15:54:56 +0000 Organization: ALSTOM Automation Distribution: world Message-ID: References: <36B363DE.28D8@pentasystems.com> <36B6C7C7.2B7F@bhp.com.au> X-Trace: news.demon.co.uk 917971241 nnrp-06:2499 NO-IDENT camk.demon.co.uk:194.222.188.130 X-Complaints-To: abuse@demon.net MIME-Version: 1.0 X-Newsreader: Turnpike Version 3.04 Lines: 27 In article <36B6C7C7.2B7F@bhp.com.au>, Connor McDonald writes >Johnny Verhoeven wrote: >> >> Hi, >> >> Is it posible to run a sored procedure once at database startup. >> If so, how ? >> >> Thanks >> >> johnny > > >Stick it in the "dbstart" script ... Run it directly or create a >dbms_job request.... > Erm... presumably this is only on UNIX? Andy -- Andy Hardy Senior IT Systems Engineer, ALSTOM Automation Tel: +44 1908 696200 Fax: +44 1908 696225 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Opinions are mine and do not necessarily reflect those of ALSTOM Automation