Re: SQL Plus won't spool to a filename that contains _at_

Kevin:

You must use the escape character '\' before the '_at_' symbol.

Examples:

SQL> spool stuart_at_work.txt
-rw-r--r-- 1 oracle dba 288 Oct 3 12:27 stuartmyinstwork.txt

SQL> spool stuart\_at_work.txt
-rw-r--r-- 1 oracle dba 291 Oct 3 12:28 stuart_at_work.txt

The first example, however, works in Windows without the escape character.

Stuart Cowen

googleQandA_at_yahoo.com (Kevin) wrote in message news:<dde36e95.0210030650.46adecce_at_posting.google.com>...
> Hello,
>
> I am using an older version of Oracle on HP-UX (no utl_file) and I am
> trying to spool to some files (using SQL Plus). Some of the filenames
> contain the "_at_" sign. When the file is created the @ sign is replaced
> with the database instance name, which is not what I want. Also the
> package that is used to create the filename can be called from
> multiple clients, so I would prefer not to make the name specific to
> SQL Plus by using an escape character. How can I get the filename
> with the _at_?
>
> I have tried set define off, set scan off.
>
> e.g.
> spool 1999/04/199904041305.00560099.ABC__at__XYZ.xml;
> exec XML_ARCHIVE.getXML(716699);
>
> The file name looks like 199904041305.00560099.ABC_MYINST_XYZ.xml;
>
> TIA
> -Kevin
Received on Thu Oct 03 2002 - 19:31:46 CEST