From: "Antonio Sant" Subject: Re: PL/SQL and v$session Date: 2000/07/07 Message-ID: #1/1 References: X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3612.1700 X-Complaints-To: abuse@iol.it X-Trace: news.infostrada.it 963002784 151.14.232.192 (Fri, 07 Jul 2000 22:46:24 MET DST) Organization: [Infostrada] NNTP-Posting-Date: Fri, 07 Jul 2000 22:46:24 MET DST Newsgroups: comp.databases.oracle.misc Hi! First of all I think that you can't update v$session because it's a view. Second v$session is part of the schema SYS: so you must try SYS.v$session Third You must give special grant to the user that run the test procedure: it must be able to read the v$session from a PL/SQL block. Because you want to update you must grant update to the user. Hope it helps Bye! Peter Smed Vestergaard ha scritto nel messaggio ... >Can anybody help me? > >How can I access v$session from PL/SQL? In an experiment I made the >following package, using a package INFO which encapsulates some of the >functionality in DBMS_APPLICATION_INFO. > >The trick would be to update v$session using INFO and then locate the row in >v$session belonging to this session by looking up for that value. > >What have I done wrong? > >create or replace package body TEST is > > function GetUniqueSessionID return varchar2 is > begin > return DBMS_SESSION.UNIQUE_SESSION_ID; > end; > > function GetSID return number is > aSID number; > aUSID varchar2(24); > oldAction char; > begin > oldAction := INFO.GetAction; > aUSID := GetUniqueSessionID; > INFO.SetAction(aUSID); > > -- This select does not work > select v$session.sid into aSID > from v$session > where v$session.action=aUSID; > > INFO.SetAction(oldAction); > return aSID; > exception > when others then > INFO.SetAction(oldAction); > return -1; > end; > >end TEST; > > >-- >Peter Smed Vestergaard >System Developer >SAXoTECH A/S http://www.saxotech.com >Hobrovej 42D, 9000 Aalborg >EMail: Peter_Vestergaard@saxotech.com >Private: Peter_Vestergaard@mail1.stofanet.dk >--- >Remove xxx on reply > >