Re: spool to symbol in vms

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_at_gmail.com> 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
>
>

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