Re: sys_context does not return anything

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: Tue, 12 Mar 2002 13:14:13 -0800
Message-ID: <Bcuj8.4$0Q4.81@inet-nntp1.oracle.com>

Maybe just a typo, but your select should say:

select sys_context('myContext', 'datamangerID')

not

select sys_context('myContext', 'datamanagerID')

Note the absence of the second "a" in "manager".

--
HTH.  Additions and corrections welcome.

Pete
Author of "Oracle8i: Architecture and Administration Exam Cram"

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA

"Eva Haiden" <eva.haiden_at_engnetworld.com> wrote in message
news:52046b21.0203110827.42c3ac04_at_posting.google.com...


> Dear Oracle users,

>

> I am using Oracle 9.0.1. I am creating an application context and try

> to retrieve the value of it for security policies. Unfortunately, the

> built-in function that I use SYS_CONTEXT does not return my set

> values. Do you have any suggestions why?

>

> I do the following:

>

> connect sys/pwd as sysdba

> grant select on sys.v_$context;

>

>

> connect sec/pwd

> select * from v$context

>

> NAMESPACE             ATTRIBUTE                 VALUE

> --------------------- ------------------------  ----------

> MYCONTEXT             DATAMANGERID              1

>

>

> connect sec/pwd

> select sys_context('myContext', 'datamanagerID') "datamanagerID" from

> dual;

>

> datamanagerID

> ------------------------

>

>

> No value is returned. Please let me know why?

>

> Thank you!

> Eva

Received on Tue Mar 12 2002 - 15:14:13 CST