Re: Session table

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