Xref: alice comp.databases.oracle.server:39527
Path: alice!news-feed.fnsi.net!enews.sgi.com!harbinger.cc.monash.edu.au!news.bhp.com.au!atbhp.corpmel.bhp.com.au!news
From: Connor McDonald <mcdonald.connor.cs@bhp.com.au>
Newsgroups: comp.databases.oracle.server
Subject: Re: How to run a stored procedure once at db start
Date: Tue, 02 Feb 1999 17:39:19 +0800
Organization: Broken Hill Proprietary Company Limited.
Lines: 22
Message-ID: <36B6C7C7.2B7F@bhp.com.au>
References: <36B363DE.28D8@pentasystems.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 3.01 (Win95; I)
To: johnny@pentasystems.com

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....

In 8i there will be a "startup" trigger
-- 
==============================================
Connor McDonald
BHP Information Technology
Perth, Western Australia
"Never wrestle a pig - you both get dirty and the pig likes it..."