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: [EMAIL PROTECTED] Personal E-Mail: [EMAIL PROTECTED] or [EMAIL PROTECTED] or [EMAIL PROTECTED] 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: [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).
