spool to symbol in vms
- From: "Barbara Baker" <barb.baker@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 7 Sep 2006 10:06:24 -0600
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
Other related posts:
