Re: sqlplus run script in neighbouring directory

From: gazzag <gareth_at_jamms.org>
Date: Tue, 11 Dec 2007 08:07:37 -0800 (PST)
Message-ID: <d2bb5ae3-4c6a-49c9-bb67-913ffb0be801@a35g2000prf.googlegroups.com>

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 Received on Tue Dec 11 2007 - 10:07:37 CST