RE: escaping v$session

[Stephen Neu]

:@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... Didn't see the other variables you were trying to interpolate... oops.
Mine won't work. :-)