Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!newsfeed.r-kom.de!news0.de.colt.net!newsfeed1.sbs.de!nntp.fujitsu-siemens.com!not-for-mail
From: Volker Hetzer <volker.hetzer@ieee.org>
Newsgroups: comp.databases.oracle.server
Subject: ORA-00920 when using function returning boolean...
Date: Fri, 09 Sep 2005 19:13:14 +0200
Organization: Fujitsu Siemens Computers GmbH
Lines: 13
Message-ID: <dfsfra$65t$1@nntp.fujitsu-siemens.com>
NNTP-Posting-Host: abg0455d.abg.fsc.net
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: nntp.fujitsu-siemens.com 1126285994 6333 172.25.146.194 (9 Sep 2005 17:13:14 GMT)
X-Complaints-To: abuse@sbs.de
NNTP-Posting-Date: Fri, 9 Sep 2005 17:13:14 +0000 (UTC)
User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317)
X-Accept-Language: en-us, en
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251188

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