Re: Way to set the prefix for use in an SQL*Plus start command ?

Brian E Dick wrote:

> I believe if you use @@xxxx sqlplus will run the called script from the same
> directory as the calling script.
>

Ahh. Interesting. I'll give it a try.

In the meantime, I'm happy to report that I found a suitable solution to my problem.
I'm used to running the GUI version of SQL*Plus on my Win2000 machine, but if I set the SQLPATH environmental variable (set SQLPATH=f:\) and then invoke SQL*Plus from cmd.exe window, this all works just great.

But I'll give your approach a try, too.

Thanks very much, Brian.

Tom

>
> "Thomas Gaines" <Thomas.Gaines_at_noaa.gov> wrote in message
> news:3E3819DB.CFCF0193_at_noaa.gov...
> > All -
> >
> > Are you aware of any way to set an assumed directory when using
> > the SQL*Plus "start" command? My various SQL*Plus scripts live
> > in directory f: on a Windows box, and those scripts have various "start"
> >
> > commands embedded in them. Do I have to edit each of those scripts
> > so that they look like "start f:\xxxx.sql" instead of "start xxxx.sql" ?
> >
> > Just like SQL*Plus assumes an ".sql" for the suffix of a filename given
> > in a "start" command, wouldn't it be cool for the user to be able
> > to set the prefix?
> >
> > Thanks for your time.
> >
> > Tom
> >
> >
Received on Wed Jan 29 2003 - 13:13:30 CST