Re: login.sql search path?

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Fri, 19 Jan 2001 21:14:27 GMT
Message-ID: <94aan9$5c8$1@nnrp1.deja.com>

SQLPATH uses operating system specific notation. It's colon separated on UNIX platforms and semicolon separated on windows.
There is another environment variable, ORACLE_PATH, which is supposed to be new way of setting path for sql scripts. Both (SQLPATH and ORACLE_PATH) are woking separately OK, but I don't know what happens if you mix them.

In article <tX_96.789$VC39.62193786_at_news.randori.com>, Doug O'Leary <dkoleary_at_ro05-24-29-232-217.ce.mediaone.net> wrote:
> Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> > Then searches the SQLPATH until it finds a login.sql and executes
it.
> > (it stops after the first one). You can specify multiple paths by
using
> > a ';' as a separator, e.g.

> > export SQLPATH=${HOME};.;/u02/app/my_app/scripts/sql
>
> According to the Oracle Admin's Reference, it's supposed to be colon
(:)
> separated. Are you sure about that semicolon?
>
> Doug
>
> --
> ------------------------
> Douglas K. O'Leary
> Senior System Administrator
> dkoleary_at_mediaone.net
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Jan 19 2001 - 15:14:27 CST