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: Autostarting stored procedures

Re: Autostarting stored procedures

From: <chandrasekar_at_my-dejanews.com>
Date: Sat, 30 Jan 1999 10:52:03 GMT
Message-ID: <78uo8h$fpm$1@nnrp1.dejanews.com>


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

Original text of this message

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