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

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Fri, 09 Sep 2005 21:05:25 +0200
Message-ID: <dfsmc4$3ib$02$1@news.t-online.com>

jkstill_at_gmail.com schrieb:
> 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
>

I think, theoretically it can be implemented with some kind of logon triggers ( which store session_id's ).
I doubt, however, that this solution is really effective...

Best regards

Maxim Received on Fri Sep 09 2005 - 14:05:25 CDT