Re: Set SQLPlus Default Directory

Marc Scheuner wrote:
>
> dmausner_at_brauntech.com (Dave Mausner) wrote:
>
> >>How can I set the default directory where SQLPlus looks for scripts to run.
> >>For example, I put all my scripts in c:\scripts. When I do a @myscript in
> >>SQLPlus, I want it to look in c:\scripts for myscript.
> >
> >set environment variable in autoexec.bat:
> >set SQLPATH=c:\scripts
> >
>
> Unfortunately, this doesn't work when using SQL*Plus 3.3 (Win16
> version) on a Win NT 3.51 machine.
>
> Any idea how I can get it to work in my configuration??
>
> Marc

I have SQL*Plus 3.2.2 on NT 3.51 and this works for me: Go into Control Panel, then System, and set SQLPATH under the User Environment Variables for <account>. It probably also would work as a system environment variable, too.

Barry Schader
barry.schader_at_medtronic.com Received on Mon Dec 30 1996 - 00:00:00 CST