Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g14g2000cwa.googlegroups.com!not-for-mail
From: jkstill@gmail.com
Newsgroups: comp.databases.oracle.server
Subject: Re: ORA-00920 when using function returning boolean...
Date: 9 Sep 2005 11:47:40 -0700
Organization: http://groups.google.com
Lines: 15
Message-ID: <1126291660.674221.300420@g14g2000cwa.googlegroups.com>
References: <dfsfra$65t$1@nntp.fujitsu-siemens.com>
NNTP-Posting-Host: 63.163.28.170
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1126291665 26950 127.0.0.1 (9 Sep 2005 18:47:45 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 9 Sep 2005 18:47:45 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.8) Gecko/20050511 Firefox/1.0.4,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: g14g2000cwa.googlegroups.com; posting-host=63.163.28.170;
   posting-account=mGBwVA0AAAB1cByzi862Uvf-W5zcEu4D
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251196

If you get this to work, it would be nice if you could post the
solution here.

The DBMS_SESSION.IS_SESSION_ALIVE function requires an input of the
form returned by the UNIQUE_SESSION_ID function.

UNIQUE_SESSION_ID does not take any arguments - it returns a value for
the current session only.  The value returned does not appear to be
available from v$session.

The IS_SESSION_ALIVE function appears to be somewhat useless, at least
from the documentation I have been able to find.

Jared