Re: search order for sqlplus scripts

Hi Leng and Thomas (you're one of my favorite golfers!)

I've been able to include multiple paths in the SQLPATH on UNIX - and it works - I don't know about DOS/Windows

Our situation is that we want to simulate search paths for sqlload .ctl files, so that if we want to test a new one, we don't have to change the shell script that is invoking sqlload; we want to simply place the test version of the .ctl file somewhere else (e.g. user's home directory or the "test" directory) that will be picked up first before the production version.

Anyone have any ideas?

In article <3388F473.7BC8_at_comsense.com>,   leng_at_comsense.com wrote:
>
> 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

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet