RE: ?

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Thu, 25 Jan 2001 15:23:11 -0800
Message-Id: <10752.127555@fatcity.com>

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_at_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"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2652.35">
<TITLE>RE: ?</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=2>&gt;-----Original Message----- </FONT>
<BR><FONT SIZE=2>&gt;From: Kevin Kostyszyn [<A HREF="mailto:kevin_at_dulcian.com">mailto:kevin_at_dulcian.com</A>] </FONT>
<BR><FONT SIZE=2>&gt;Sent: Thursday, January 25, 2001 11:02 AM </FONT>
<BR><FONT SIZE=2>&nbsp;</FONT>
<BR><FONT SIZE=2>&gt;Does anyone have any idea how I should solve the following problem </FONT>
<BR><FONT SIZE=2>&gt;&nbsp; 1&nbsp; select next_day(sysdate, 'friday') </FONT>
<BR><FONT SIZE=2>&gt;&nbsp; 2* from dual </FONT>
<BR><FONT SIZE=2>&gt;SQL&gt; / </FONT>
<BR><FONT SIZE=2>&gt;from dual </FONT>
<BR><FONT SIZE=2>&gt;&nbsp;&nbsp;&nbsp;&nbsp; * </FONT>
<BR><FONT SIZE=2>&gt;ERROR at line 2: </FONT>
<BR><FONT SIZE=2>&gt;ORA-00600: internal error code, arguments: [17182], [845146248], [], [], [], </FONT>
<BR><FONT SIZE=2>&gt;[], [], [] </FONT>
<BR><FONT SIZE=2>&gt; </FONT>
<BR><FONT SIZE=2>&gt;8.1.6&nbsp; NT</FONT>

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 ;

<P><FONT SIZE=2>BANNER</FONT>
<BR><FONT SIZE=2>----------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production</FONT>
<BR><FONT SIZE=2>PL/SQL Release 8.1.6.0.0 - Production</FONT>
<BR><FONT SIZE=2>CORE&nbsp;&nbsp;&nbsp; 8.1.6.0.0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Production</FONT>
<BR><FONT SIZE=2>TNS for 32-bit Windows: Version 8.1.6.0.0 - Production</FONT>
<BR><FONT SIZE=2>NLSRTL Version 3.4.1.0.0 - Production</FONT>
</P>

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

<P><FONT SIZE=2>NEXT_DAY(</FONT>
<BR><FONT SIZE=2>---------</FONT>
<BR><FONT SIZE=2>26-JAN-01</FONT>

Received on Thu Jan 25 2001 - 17:23:11 CST