Re: search order for sqlplus scripts

[Quoted] Hi Thomas,

Have you got it to work with multiple SQLPATHs? eg. SQLPATH=c:\sql;c:\leng\sql.

I've only had it working with a single path.

Also, when I do an edit of a file in the SQLPATH, it fails. SQL*Plus seems to be only interested in picking up files from my working current directory. But if I try and run a file in the SQLPATH, it works well. It only fails during "edit"

tia,
Leng.

Thomas Kyte wrote:
>
> On Fri, 23 May 1997 11:41:22 -0600, lipnej_at_pfizer.com wrote:
>
> >Has anyone been able to come up with a clever way of creating search path
> >functionality for sqlplus scripts, e.g.,
> >
> >SQL> start myscript
> >
>
> Set the environment SQLPATH. It'll search this like DOS does the PATH for
> scripts to run...
>
> Thomas Kyte
> tkyte_at_us.oracle.com
> Oracle Government
> Bethesda MD
>
> http://govt.us.oracle.com/ -- downloadable utilities
>
> ----------------------------------------------------------------------------
> Opinions are mine and do not necessarily reflect those of Oracle Corporation
Received on Mon May 26 1997 - 00:00:00 CEST