Re: Getting SID in PL/SQL

From: Marek Abram <marek_at_ensib.ee>
Date: Tue, 04 May 1999 20:04:47 +0300
Message-ID: <372F28AF.3E32262B@ensib.ee>

select userenv('SESSIONID') into ... from dual;

Thomas Keller wrote:

> I need a value that's unique at a time (but all values should be in the
> smallest possible range). My idea was to use the SID (for example from
> V$SESSION).
> Is it possible to get the Value from anywhere? When I try a SELECT from
> V$SESSION in a package I get an error when compiling the package...

--
Marek Abram
AS Medisoft
tel (+37 244) 77 603

(+37 2) 6 208 479 Received on Tue May 04 1999 - 12:04:47 CDT