Home -> Usenet -> comp.databases.oracle -> SQL Plus won't spool to a filename that contains _at_

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

From: Kevin <googleQandA_at_yahoo.com>
Date: 3 Oct 2002 07:50:01 -0700
Message-ID: <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 - 16:50:01 CEST












Original text of this message