capturing host variables
From: traceable1 <traceable1_at_hotmail.com>
Date: 8 Oct 2001 06:20:01 -0700
Message-ID: <8551d8c9.0110080520.6926925a_at_posting.google.com>
Date: 8 Oct 2001 06:20:01 -0700
Message-ID: <8551d8c9.0110080520.6926925a_at_posting.google.com>
I need to get the current OS directory from within SQL*Plus. I have a
SQL*Plus script which calls several other SQL*Plus scripts. This
script needs to be able to run from anywhere, but all of the scripts
will be in the same directory (I just don't which one). So the user
will run the main SQL*Plus script and I want wo preface the calls with
the directory by way of a variable.
Main script: call_ora.sql
_at_{directory path}ora1.sql
In windows, I know "CHDIR" will give me the current directory, but I
don't know how to get it or use it in Oracle.
Any help is very much appreciated!
_at_{directory path}ora2.sql
Thanks,
Tracy
Received on Mon Oct 08 2001 - 15:20:01 CEST