FAQ
If unix, should be able to invoke a unix shell with a command to determine.
For Windows, use PL/SQL to essentially the same.

Thank You

Stephen P. Karniotis
Compuware Corporation
Direct: (313) 227-4350
Toll Free: (800) 462-7740 ext. 74350

Mobile: (248) 408-2918
Email: Stephen.Karniotis_at_Compuware.com
Web: www.compuware.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
On Behalf Of Vergara, Michael (TEM)
Sent: Thursday, May 13, 2004 1:13 PM
To: Oracle-L (E-mail)
Subject: Oracle 9iR2, HP-UX 11i, (How) Can I...?

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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 3 of 5 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedMay 13, '04 at 1:40p
activeMay 13, '04 at 6:21p
posts5
users5
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase