Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-00920 when using function returning boolean...
Hi!
I'm trying to find out which sessions, out of a set, are still alive:
select SessionId
from (select SessionId from CVC_EDDY1 UNION select SessionId from CVC_EDDY2) where dbms_session.is_session_alive(SessionId);
Unfortunately oracle then tells me that I use an invalid relational operator. I've tried ='TRUE' and =(1=1) but to no avail.
Can anybody tell me what I'm doing wrong?
Lots of Greetings and Thanks!
Volker
Received on Fri Sep 09 2005 - 12:13:14 CDT