On 11 Pro, 20:14, sybra..._at_hccnet.nl wrote:
> On Tue, 11 Dec 2007 08:22:55 -0800 (PST), Stan.S..._at_gmail.com wrote:
> >On 11 Pro, 17:07, gazzag <gar..._at_jamms.org> wrote:
> >> On 11 Dec, 15:03, Stan.S..._at_gmail.com wrote:
>
> >> > Hi,
> >> > I need to run one script from another which is in another directory
> >> > and i can't work it out. Here is how it is:
> >> > +parent_dir
> >> > +child_dir_1
> >> > +script_1.sql
> >> > +child_dir_2
> >> > +script_2.sql
>
> >> > I want to run script_2.sql from script_1.sql and expected to use
> >> > something like following:
> >> > @@..\child_dir_2.sq\script_2.sql but it doesn't work and i keep
> >> > getting SP2-0310: unable to open file error no matter what i try. Any
> >> > help will be appreciated.
>
> >> SQL*Plus from a command prompt (sqlplus.exe) or SQL*Plus for Windows
> >> (sqlplusw.exe)?
>
> >> The former will run scripts relative to the directory you were in when
> >> you logged into SQL*Plus. The latter defaults to your ${ORACLE_HOME}/
> >> bin directory.
>
> >> What happens if you fully qualify the pathnames?
>
> >> HTH
>
> >> -g
>
> >I use the command prompt one. I don't want to depend on the directory
> >I start sqlplus from nor on any other directory, so I wanted to use @@
> >instead of @, but it apparently doesn't work :-(
>
> @@ works fine.
> If you would have looked up @@ in the sqlplus reference manual, you
> would have noticed @@ runs scripts in the *same* directory as the
> calling script.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Well, I am aware of the fact that @@ runs script in the "same"
directory, but i wanted to run a script relatively to the "same"
directory using "..\" to get to parent directory or to
"\subdirectory". And this is what IMHO doesn't work with @@. Although
it is fine with @.
Received on Wed Dec 12 2007 - 07:58:29 CST
