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

Cool - that was the problem: I did not have a SQLPATH variable correct. It was pointing to opt/app/oracle/local/sql/login.sql instead of opt/app/oracle/local/sql

Thanks,
Anoop

On Jan 10, 11:32 am, "Mark D Powell" <Mark.Pow..._at_eds.com> wrote:
> 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,
> > BrianIt 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 - 11:56:17 CST