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

Andy Hardy schrieb:
>
> In article <36B6C7C7.2B7F_at_bhp.com.au>, Connor McDonald <mcdonald.connor.
> cs_at_bhp.com.au> 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

Just got a message from oracle support concerning automatic startup of the oracle services and this message included an interesting point which may help you to solve your problem.

    Within the Registry insert a new entry under the key HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/

    Windows NT/CurrentVersion/Winlogon/System for your CMD-File    example:

           "lsass.exe, c:\orant\database\strt<SID>.cmd"     Delimeted by comma you can add several command files. Didn't test may be you do and report about your experiences?

HTH
Matthias
--
Matthias.Gresz_at_Privat.Post.DE

Always log on the bright side of life.
http://www.stone-dead.asn.au/movies/life-of-brian/brian-31.htm Received on Thu Feb 04 1999 - 01:52:17 CST