Christian, David, Thanks, I tried MetaLink, but it just tells me that there is a problem. I am not a DBA, just a lowly user. My DBA had already opened a TAR with support. The plan is to apply a security patch and a patch for this error sometime in February. Maybe I just haven't figured out how to use MetaLink properly. The reason I ask was more out of curiosity; there seems to be folks on here that know Oracle better than Oracle. This query was so darn simple that I am still amazed that it could cause an error. I was hoping for a better workaround than a UNION ALL of two queries. Mind you, "where churn_dt in ( '01-jan-2004', '31-dec-2004' )", does not work either. Michael -----Original Message----- From: Christian Antognini [mailto:Christian.Antognini@xxxxxxxxxxxx] Sent: Tuesday, January 24, 2006 3:45 PM To: Coll-Barth, Michael Cc: oracle-l@xxxxxxxxxxxxx Subject: RE: odd error Michael Go here http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_ database_id=NOT&p_id=153788.1 and enter qksmmAdjustStatistics1 as first parameter. HTH Chris >-----Original Message----- >From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of >Michael.Coll-Barth@xxxxxxxxxxxxxxxxxxx >Sent: 24 January 2006 21:21 >To: oracle-l@xxxxxxxxxxxxx >Subject: odd error > >All, > >I am getting a strange error with the code below. Does anyone have an >explanation? > >thanks, >Michael > > >SQL> select unique market_cd, churn_dt > 2 from eisweb.eis_ret_cmbd_rpt > 3 where ( churn_dt = '01-jan-2004' or churn_dt = '31-dec-2004' ) > 4 -- and market_cd > chr(0) > 5 ; >from eisweb.eis_ret_cmbd_rpt > * >ERROR at line 2: >ORA-00600: internal error code, arguments: [qksmmAdjustStatistics1], [], [], >[], [], [], [], [] > > >The information contained in this message and any attachment may be >proprietary, confidential, and privileged or subject to the work >product doctrine and thus protected from disclosure. If the reader >of this message is not the intended recipient, or an employee or >agent responsible for delivering this message to the intended >recipient, you are hereby notified that any dissemination, >distribution or copying of this communication is strictly prohibited. >If you have received this communication in error, please notify me >immediately by replying to this message and deleting it and all >copies and backups thereof. Thank you. > >-- >//www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l