Re: automatic execution of sql stored procedure

Hi,

are u talking about this, I donot reboot database till next weekend so just asking:

create or replace trigger <trigger_name> after startup on database
begin

     call <procedure name(arguments)>;
end;

thanks a lot
sunil

rboyle_at_cyantel.com (Robert Boyle) wrote in message news:<8729a6fe.0105300105.654b57fe_at_posting.google.com>...
> sdua_at_solutionsny.com (Sunil Dua) wrote in message news:<bc03ebd5.0105291844.8f47c7c_at_posting.google.com>...
> > Hello there,
> >
> > I am having my oracle 8.1.5 on a sun solaris box. I have to execute
> > some stored procedure, available in a text file, at boot time right
> > after my oracle server get started.... is there any way out thru which
> > I can make it automated at boot time.
> >
> > thanks
> > sunil dua
>
>
> What you need is a startup Trigger for the database.
Received on Thu May 31 2001 - 17:53:07 CEST