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 :-(
Received on Tue Dec 11 2007 - 10:22:55 CST
