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

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_sele...ha t_is_wrong

Best regards

Maxim

OK Thanks...