Oracle 9iR2, HP-UX 11i, (How) Can I...?

  • From: "Vergara, Michael (TEM)" <mvergara@xxxxxxxxxxx>
  • To: "Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 13 May 2004 10:12:31 -0700

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
-----------------------------------------------------------------

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2004