Re: ORA-00920 when using function returning boolean...

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

.

Relevant Pages

  • Re: how to find total open database links in a database?
    ... documentation clearly says open_links is for each session. ... Yong Huang ... Prev by Date: ...
    (comp.databases.oracle.server)
  • Re: Primary/non primary sessions
    ... > amogh wrote: ... >> non-migratable parent session. ... documentation does NOT constitute 'well documented'. ...
    (comp.databases.oracle.server)
  • Re: Memory Mapping Anomaly
    ... internally (we often write our own suplementary documentation on stuff like ... I can, as a non privileged user, open an object from one session when the ... This is done by simply prefixing with the session id of the session names ... It is not documented and just mentioning NOT to use it ...
    (microsoft.public.win32.programmer.kernel)
  • Re: Session Variables - why arent novice developers warned?
    ... the use of Session Variables? ... I think it is a basic role of documentation to point out potential ... integrity of an application which relies on session state is COMPLETELY ... Such that developers seeking basic guidance will not fail to ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Session Variables - why arent novice developers warned?
    ... You can research session state very thoroughly without finding any ... I think it is a basic role of documentation to point out potential ... Such that developers seeking basic guidance will not fail ...
    (microsoft.public.dotnet.framework.aspnet)