RE: odd error

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_at_trivadis.com] Sent: Tuesday, January 24, 2006 3:45 PM
To: Coll-Barth, Michael
Cc: oracle-l_at_freelists.org
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of
>Michael.Coll-Barth_at_VerizonWireless.com
>Sent: 24 January 2006 21:21
>To: oracle-l_at_freelists.org
>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.
>
>--
>http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l