Re: Spooling to same directory as execution
From: Larry <emat_at_qnet.com>
Date: 1995/10/17
Message-ID: <45uuco$oqm_at_ukelele.qnet.com>#1/1
Date: 1995/10/17
Message-ID: <45uuco$oqm_at_ukelele.qnet.com>#1/1
In article <45ugg9$8lt_at_ixnews5.ix.netcom.com>, chuckh_at_ix.netcom.com
says...
>
>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!
>
Set a variable and then spo $VAR/a.lst
Received on Tue Oct 17 1995 - 00:00:00 CET