> -----Original Message-----
> From: Stephen Neu [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 25, 2001 12:04 PM
> To: Perl Beginners (E-mail)
> Subject: RE: escaping v$session
>
>
> Try 'v$session' instead of "v$session"
> The single quote doesn't interpolate variables like the double-quote.
this is what I am trying todo
@active = qx(
sqlplus -S $RTDUSER/$RTDPASS\@$RTD_ORACLE_SID <<-!
select count(distinct(process)) ACTIVE from ---> v$session <---
where last_call_et < 60 and
process in (select ltrim(rtrim(to_char(process_id) )) from session_list);
quit
!
);
I have tried v\$session and get
ORA-00903: invalid table name
'v$session' gives
Global symbol "$session" requires explicit package name at betadiag.pl line
238.
Execution of betadiag.pl aborted due to compilation errors.
and 'v\$sessions gives the same as v\$session
so, what is the magic to this madness?
Ron
