RE: I want to change directory inside SQL script

Have u tried setting SQLPATH variable?

Thanks,
Arul.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Thiru Pandian Sent: 27 January 2005 14:33
To: Oracle-L_at_freelists.org
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

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l