ORA-02070: database does not support operator SYS_CONTEXT in this

For what it is worth... I've been battling this problem on Oracle 9i Release 2 and finally got it into Oracle as a bug. "ORA-02070: database does not support operator SYS_CONTEXT in this context." (Oracle BUG Reference 2624342) when using an object that contains SYS_CONTEXT. I don't know if anyone has encountered this problem but I figured I would try to save someone from utter fustration trying to debug it. The bug and the work around code can be found in a script file on my web site http://www.oracle-developer.us/code.htm (go to the bottom of the page). I'll give an update when Oracle comes up with a fix. Gregory N. Mirsky
Project Manager
Financial Systems / HRMS Payroll

The Estee Lauder Companies, Inc.
(Estée Lauder, Aramis, Clinique, Prescriptives, Origins, M·A·C, Bobbi Brown
essentials, Tommy Hilfiger Toiletries, jane, Donna Karan, Crème de la Mer, Aveda, Stila, Kate Spade fragrances and Jo Malone) 7 Corporate Center Drive
Melville, NY 11747

Telephone: 1-631-531-1807
FAX: 1-631-531-1886
E-Mail: gmirsky_at_estee.com

Personal E-Mail: gmirsky_at_optonline.net or gmirsky_at_coin-collector.us or gmirsky_at_oracle-developer.us
Web: www.coin-collector.us www.oracle-developer.us

"Feed an opportunity. Starve a problem." ~ Peter F. Drucker

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mirsky, Greg
  INET: gmirsky_at_Estee.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).