Setting Directory Path in SQL*Plus

I am trying to write an master installation script that will install many tables, packages etc into an Oracle 8.1.7 database by calling several large [Quoted] subscripts in sequence.

A certain directory structure has been created (for a good reason) to store [Quoted] these subscripts in different places but all within a master directory. What I am trying to do is set the master script up so that it can point itself to a different sub-directory and call a script but to do so relative [Quoted] to the original directory.

This will be running on Windows 2000 Server, but I don't want to actually hard code the directory path into the script as there is no guarantee that the drive names will be the same etc, so I don't just want to say
"_at_E:\etc\etc\etc".

Is there any way I can change directories in an SQL script by using a DOS-style command or something to do something like "cd ..\..\scripts\blah\blah"? Is there maybe an environment variable I can't find that will do this?

Many thanks...

--


"Managing senior programmers is  | Justin Wigg   -   Hobart, AUSTRALIA


like herding cats." - Dave Platt | Reply:  justin_at_icsmultimedia.com.au