Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Autostarting stored procedures
Hi doug walter , To run some sql commands & stored procedures during
session startup , we can make use of the file GLOGIN.SQL . It is more like a
autoexec.bat in DOS or .PROFILE in UNIX . But I don't think it will work for
ORACLE STARTUP .
cheers
chandrasekar
In article <78oftl$47h$1_at_nnrp1.dejanews.com>,
doug_walters_at_my-dejanews.com wrote:
> MSSQL Server has a stored procedure titled sp_procoption
> which allows a stored procedure to be run when SQL Server
> starts.
>
> Is there a way I can run a set of SQL commands in a similar
> fashion in Oracle during startup? The method would have to
> be such that the "procedure" could be added to the Oracle
> server via a programming language (e.g. odbc).
>
> Thanks
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Jan 30 1999 - 04:52:03 CST