Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Session table

Re: Session table

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Wed, 17 May 2006 10:18:44 +0200
Message-ID: <446add9c$0$11066$9b4e6d93@newsread4.arcor-online.net>


Alen Cappelletti schrieb:
> Hi,
> I try on my Procedure the select the id of my session....
>
> ---------------
> SELECT
> sid
> INTO
> var_DBsessionId
> FROM sys.V$SESSION
> WHERE audsid = SYS_CONTEXT('userenv','sessionid');
> ---------------
> but always have the same error..."table or view not exist".
>
>
> If I try this simple select from my SQL software (I log-in in this as
> the same user of the procedure) I have the rigth result.
>
> I don't have undestand where is the problem.
> My user have DBA permission and PROCEDURE EXECUTE.
>
> I hope someone can hel me.
> Alen
>

This is FAQ. Try search this newsgroup before posting (in this particular case on "plsql role grant") or look at http://www.orafaq.com/faq/i_can_select_from_sql_plus_but_not_from_pl_sql_what_is_wrong

Best regards

Maxim Received on Wed May 17 2006 - 03:18:44 CDT

Original text of this message

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