capturing host variables

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
_at_{directory path}ora2.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!
Thanks,
Tracy Received on Mon Oct 08 2001 - 15:20:01 CEST