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

From: Karniotis, Stephen <Stephen.Karniotis_at_compuware.com>
Date: Thu, 13 May 2004 15:22:05 -0400
Message-ID: <8D81DA9D264CD311A60C0008C75D553B1775AE81@cwus-dtw-pri02.compuware.com>

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 [mailto: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

Received on Thu May 13 2004 - 15:02:17 CDT