RE: I want to change directory inside SQL script

  • From: <arul.kumar@xxxxxx>
  • To: <tpandian@xxxxxxxxx>
  • Date: Thu, 27 Jan 2005 15:19:57 -0000

Have u tried setting SQLPATH variable?

Thanks,
Arul.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Thiru Pandian
Sent: 27 January 2005 14:33
To: Oracle-L@xxxxxxxxxxxxx
Subject: I want to change directory inside SQL script


Hi,=20

I want to change the directory from sql script. I am applying few
application patches which requires punch of sql needed to be run from
different directory, i would like to automate this.

@script1
change the directory=20
@script2

you may say that i should do @@  or specify the directory for parent
script. But in the script they did not have @@. Is there any way do
this?



--=20
Thiru Pandian=20
Sr. Oracle DBA
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l

Other related posts: