query trouble

    I've got a table that maintains a list of logins (I'm with an ISP), and the relevant data. what I'm trying to do is search that table for people with dual simultaneous connections. I can't seem to get it to work, and I'm at a loss as to why. any input would be greatly appreciated. Please email replies to wyma69_at_nidlink.com .

What I've got is this:
PROCEDURE GET_MULTS IS cursor names is
select UNAME, LONG_DATE, OUT_DATE
from MAIN.RADIUS_LOGS
where (TO_DATE(LONG_DATE, 'dy mon dd HH24:MI:SS YYYY')) between (SYSDATE-1) and SYSDATE
order by (TO_DATE(LONG_DATE, 'dy mon dd HH24:MI:SS YYYY'));

BEGIN for dual_log in names loop

SELECT UNAME, LONG_DATE, OUT_DATE, SESS_LENGTH, CALLED_FROM into :UNAME, :LONG_DATE, :OUT_DATE, :SESS_LENGTH, :CALLED_FROM from MAIN.RADIUS_LOGS
where UNAME=dual_log.UNAME
and (TO_DATE(LONG_DATE, 'dy mon dd HH24:MI:SS YYYY')) between (SYSDATE-1) and SYSDATE
and (TO_DATE(LONG_DATE, 'dy mon dd HH24:MI:SS YYYY')) between (TO_DATE(dual_log.LONG_DATE, 'dy mon dd HH24:MI:SS YYYY')) and (TO_DATE(dual_log.OUT_DATE, 'dy mon dd HH24:MI:SS YYYY'));

end loop;

END; Received on Mon May 03 1999 - 19:48:50 CEST