Re: SPOOL command in same script for Windows & UNIX clients

Stephen Haunch wrote:
> Hi,
>
> I have SQL*Plus scripts which run primarily through the Windows SQL*Plus
> client, these scripts contain SPOOL commands like this: -
>
> SPOOL Output\uunl-135-&reportdate..txt
>
> If I were to run this script using a UNIX SQL*Plus client the SPOOL command
> shown above would cause problems because it should be: -
>
> SPOOL Output/uunl-135-&reportdate..txt
>
> Is there a way to make SQL*Plus figure out which type of directory delimiter
> to use, i.e. \ for Windows and / for UNIX?
>
> Any help would be appreciated!
>
> Steve
>

I don't immediately see a solution for sql*plus itself, but you could pass the directory as a command-line parameter?

-- 

Gerard H. Pille