Message-Id: <10752.127555@fatcity.com> From: Jacques Kilchoer Date: Thu, 25 Jan 2001 15:23:11 -0800 Subject: RE: ? This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C08725.C8825BE0 Content-Type: text/plain; charset="iso-8859-1" >-----Original Message----- >From: Kevin Kostyszyn [mailto:kevin@dulcian.com] >Sent: Thursday, January 25, 2001 11:02 AM >Does anyone have any idea how I should solve the following problem > 1 select next_day(sysdate, 'friday') > 2* from dual >SQL> / >from dual > * >ERROR at line 2: >ORA-00600: internal error code, arguments: [17182], [845146248], [], [], [], >[], [], [] > >8.1.6 NT Query was successfull on an 8.1.6.0.0 database on Windows 2000, 5.00.2195, Service Pack 1 SQL> select * from v$version ; BANNER ---------------------------------------------------------------- Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production PL/SQL Release 8.1.6.0.0 - Production CORE 8.1.6.0.0 Production TNS for 32-bit Windows: Version 8.1.6.0.0 - Production NLSRTL Version 3.4.1.0.0 - Production SQL> select next_day (sysdate, 'friday') from dual ; NEXT_DAY( --------- 26-JAN-01 ------_=_NextPart_001_01C08725.C8825BE0 Content-Type: text/html; charset="iso-8859-1" RE: ?

>-----Original Message-----
>From: Kevin Kostyszyn [mailto:kevin@dulcian.com]
>Sent: Thursday, January 25, 2001 11:02 AM
 
>Does anyone have any idea how I should solve the following problem
>  1  select next_day(sysdate, 'friday')
>  2* from dual
>SQL> /
>from dual
>     *
>ERROR at line 2:
>ORA-00600: internal error code, arguments: [17182], [845146248], [], [], [],
>[], [], []
>
>8.1.6  NT


Query was successfull on an 8.1.6.0.0 database on Windows 2000, 5.00.2195, Service Pack 1

SQL> select * from v$version ;

BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
PL/SQL Release 8.1.6.0.0 - Production
CORE    8.1.6.0.0       Production
TNS for 32-bit Windows: Version 8.1.6.0.0 - Production
NLSRTL Version 3.4.1.0.0 - Production

SQL> select next_day (sysdate, 'friday') from dual ;

NEXT_DAY(
---------
26-JAN-01