spool to symbol in vms

From: Barbara Baker <barb.baker_at_gmail.com>
Date: Thu, 7 Sep 2006 10:06:24 -0600
Message-ID: <47a6f72b0609070906w23b96348vc9af07c94fe5926a@mail.gmail.com>

OpenVMS 7.3-1
Oracle 9.2.0.4

Hi, all.
Does anyone know how to spool to a symbol in vms? Here's my dcl. I want to spool to the file identified by the symbol tmp.
$ val_sid = f$trnlnm("ora_sid")

  $!

$ sho sym val_sid
$ tmp = "tmp_"+"''val_sid'"+".txt"
$ sho sym tmp
$ sqlplus "/ as sysdba"

     spool 'tmp
     select '$ STOP/IDENTIFICATION=' || p.spid proc_id from v$session s,

v$process
. . . . .

Thanks for any help!
Barb

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 07 2006 - 11:06:24 CDT