Here's my hack attempt.. I won't explain it because I have to leave.. but it should/ might be self explanatory.. --- Shell script to execute sqlplus and the sql script $ cat x #!/bin/ksh sqlplus -s / @x.sql <<-EOT `pwd` EOT --- The sql script $ cat x.sql set pause off accept PWD select '&PWD' PWD from dual; --- Sample output $ ./x old 1: select '&PWD' PWD from dual new 1: select '/db01/app/oracle' PWD from dual PWD -------------------------------- /db01/app/oracle Shawn 8D > Hi Everyone: > > Is it possible to determine the current working directory as I > am running a SQL script from the command line? > > I have a script that I want to pass a file name, and I want the=20 > log file to be in the same directory as the script, which is not > necessarily the same location as the passed file name. So I am=20 > trying to find a way to determine the current 'pwd', and feed that > value to a utl_file.fopen call. Currently I prompt the user for > the directory, but I'd like to find something smoother. > > I am looking through FM's and web sites, but I thought I'd ask the > group too. > > Cheers, > Mike > > --- > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= > > Michael P. Vergara > Oracle DBA > Guidant Corporation > www.guidant.com <http://www.guidant.com/> > > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------