SQL comparison addition: Resolution...

From: Chris Stephens <ChrisStephens_at_affina.com>
Date: Fri, 21 Nov 2003 08:49:31 -0800
Message-ID: <F001.005D770A.20031121084931@fatcity.com>

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: ChrisStephens_at_affina.com

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: ListGuru_at_fatcity.com (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).

Received on Fri Nov 21 2003 - 10:49:31 CST