A few weeks ago I had a problem with the following query not returning rows:
Select count(*) .
from global.client_dim a
where a.reports_login = sys_context('userenv','session_user');
even though the following query indicated a match (thanks to whomever
suggested I dump the fields):
SQL> select sys_context('userenv','session_user'),
> 2 dump(sys_context('userenv','session_user')), a.reports_login,
> 3 dump(a.reports_login)
> 4 from global.client_dim a
> 5 WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN;
>
> SYS_CONTEXT('USERENV','SESSION_USER')
>
----------------------------------------------------------------------------
> ------------------------
> DUMP(SYS_CONTEXT('USERENV','SESSION_USER'))
>
----------------------------------------------------------------------------
> ------------------------
> REPORTS_LOGIN
> ------------------------------
> DUMP(A.REPORTS_LOGIN)
>
----------------------------------------------------------------------------
> ------------------------
> REPORTS_DELTA
> Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65
> REPORTS_DELTA
> Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65
I said I would post the resolution to this.
It ended up being a bug in 9203. Not sure which bug.
Support insisted that we patch to 9204 and the problem went away.
Thanks for everyone's help.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Chris Stephens
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
