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