On Mon, Jun 25, 2001 at 02:09:59PM -0400, Chas Owens wrote:
> @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
> !
Oh, I wasn't aware this was going through the shell (I hadn't been paying
attention to the discussion). That's what's doing the interpolation of
$session.
Michael
--
Administrator www.shoebox.net
Programmer, System Administrator www.gallanttech.com
--
