Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to run a stored procedure once at db start

Re: How to run a stored procedure once at db start

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Tue, 02 Feb 1999 17:39:19 +0800
Message-ID: <36B6C7C7.2B7F@bhp.com.au>


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..." Received on Tue Feb 02 1999 - 03:39:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US