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 -> Re: ORA-00920 when using function returning boolean...

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

From: <jkstill_at_gmail.com>
Date: 9 Sep 2005 11:47:40 -0700
Message-ID: <1126291660.674221.300420@g14g2000cwa.googlegroups.com> 





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
Received on Fri Sep 09 2005 - 13:47:40 CDT












Original text of this message













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