Re: spool to symbol in vms

  • From: "Barbara Baker" <barb.baker@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 7 Sep 2006 10:35:12 -0600

Well, duh.  I can do this in sqlplus.  (grab instance_name from v$instance
and spool to something&instancename)

Sorry for the e-mail.  It's been a loooooooongggg couple of weeks.
Barb


On 9/7/06, Barbara Baker <barb.baker@xxxxxxxxx> wrote: 

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:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2006