Re: Oracle 9i | login.sql does not run on login by default

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 10 Jan 2007 08:32:20 -0800
Message-ID: <1168446740.621799.192230@i56g2000hsf.googlegroups.com>

On Jan 10, 10:45 am, Brian Peasland <d..._at_nospam.peasland.net> wrote:
> mai..._at_bmlam.de wrote:
> > In my experience, under Unix, Oracle looks for login.sql in your
> > current directory. If none is found, it looks for login.sql in $SQLPATH
>
> > hth
>
> > Bon-Minh LamThe order for finding the login.sql script is:
>
> 1) Your current directory
> 2) The directories listed (in order) in your SQLPATH environment variable
> 3) The ORACLE_HOME/sqlplus/admin directory
>
> Finally, the contents of the ORACLE_HOME/sqlplus/admin/glogin.sql script
> are executed.
>
> HTH,
> Brian
>

It is not very good programming practice to use Oracle keywords as variable names:
>>

SET SQLPROMPT '&sqlprompt> '
UNDEFINE sqlprompt
<<

&sqlprompt should be given a different name

HTH -- Mark D Powell -- Received on Wed Jan 10 2007 - 10:32:20 CST