Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-00920 when using function returning boolean...

ORA-00920 when using function returning boolean...

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Fri, 09 Sep 2005 19:13:14 +0200
Message-ID: <dfsfra$65t$1@nntp.fujitsu-siemens.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US