Re: login.sql

ThanX for your responce.
I did not find a SQNPATH variable in my environments, however I did have a variable caled ORACLE_PATH. ORACLE_PATH did include the directory where the login.sql file resides. Could it be that ORACLE_PATH is also used when looking for the login.sql file?
Is SQLPATH realy correct or did you mean ORACLE_PATH? (No offence. I am trying to get a complete and correct answer. For myself and for anybody following this thread

On Wed, 4 Nov 1998 12:23:46 -0000, "B.Sc Yassir Khogaly" <yassir_at_khogaly.freeserve.co.uk> wrote:

>Hi
>This is from Oracle Corporation Oracle7 Administrator's Reference for UNIX
>/ Administering SQL*Plus. This will give you an idea.
>
>Regards
>
>
>
>Setup Files
>The setup files for SQL*Plus are glogin.sql, the global setup file, and
>login.sql, for local and individual use. The glogin.sql and login.sql files
>contain either SQL statements or SQL*Plus commands that you choose to
>execute at the beginning of each SQL*Plus session. When you invoke SQL*Plus,
>glogin.sql is read first, followed by login.sql.
>
>The glogin.sql File
>The glogin.sql file is executed regardless of your current directory. The
>DBA can customize the glogin.sql file. When you install (rather than
>upgrade) SQL*Plus, existing glogin.sql files are deleted. The glogin.sql
>file is in $ORACLE_HOME/sqlplus/admin.
>
>The login.sql File
>The SQLPATH environment variable contains a list of directories, separated
>by colons. SQL*Plus searches for the login.sql file in the directories
>listed in SQLPATH.
>Following is a sample login.sql file:
>
>
>set echo off
>set feedback 4
>set pause on
>set pause "PLEASE PRESS RETURN TO CONTINUE"
>set message on
>set echo on
>
>azariae_at_amdocs.com wrote in message <71pbkm$8ab$1_at_nnrp1.dejanews.com>...
>>I have the file login.sql in a directory that is not my homedir but it DOES
>>take effect.
>>how can this be? is there an environment variable defining where login.sql
>can
>>be found?
>>I ma using Oracle 7.* and 8.* on HP-UX Unix Computers.
>>Please also mail responses to mailto:\\azariae_at_amdocs.com as it is hard for
>me
>>to connect to the net (firewalls and other stuff.)
>>
>>ThanX, in advance for any input.
>>
>>-----------== Posted via Deja News, The Discussion Network ==----------
>>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>
>begin 666 Yassir Khogaly.vcf
>M0D5'24XZ5D-!4D0-"E9%4E-)3TXZ,BXQ#0I..DMH;V=A;'D[66%S<VER#0I&
>M3CI987-S:7(_at_2VAO9V%L>0T*5$E43$4Z4V5N:6]R($]R86-L92!$0D$-"E1%
>M3#M(3TU%.U9/24-%.BLT-"_at_P*3$X,2 T-C T,#0R#0I414P[0T5,3#M63TE#
>M13HK-#0T,3$Y,#8W-S8-"D%$4CM(3TU%.CL[.SM+96YT.SM%;F=L86YD#0I,
>M04)%3#M(3TU%.T5.0T]$24Y'/5%53U1%1"U04DE.5$%"3$4Z2V5N=#TP1#TP
>M045N9VQA;F0-"E523#IH='1P.B\O=W=W+FMH;V=A;'DN9G)E97-E<G9E+F-O
>M+G5K#0I54DPZ:'1T<#HO+W=W=RYA965U+F]R9RYU:PT*14U!24P[4%)%1CM)
>M3E1%4DY%5#IY87-S:7) :VAO9V%L>2YF<F5E<V5R=F4N8V\N=6L-"E)%5CHQ
><.3DX,3$P-%0Q,C(S-#5:#0I%3D0Z5D-!4D0-"_at_``
>`
>end
>
Received on Thu Nov 05 1998 - 14:26:39 CET