Spooling to same directory as execution
From: Chuck Hamilton <chuckh_at_ix.netcom.com>
Date: 1995/10/16
Message-ID: <45ugg9$8lt_at_ixnews5.ix.netcom.com>#1/1
Date: 1995/10/16
Message-ID: <45ugg9$8lt_at_ixnews5.ix.netcom.com>#1/1
Is there a way to specify in sqlplus that you want to spool a file to
whatever directory the currently executing script is in?
For example: suppose I have a script (a.sql) that resides in directory
c:\scripts, and that script contains a line that says "spool a.lst".
My current working directory in sqlplus is c:\current. If I execute
"_at_c:\scripts\a.sql", I want it to spool to c:\scripts, not c:\current.
How do I do it WITHOUT hardcoding the full path name?
--
Chuck Hamilton
chuckh_at_ix.netcom.com
Incoming fire has the right of way!
Received on Mon Oct 16 1995 - 00:00:00 CET