RE: ?

From: Rao, Maheswara <Maheswara.Rao_at_Sungardp3.com>
Date: Thu, 25 Jan 2001 17:23:20 -0500
Message-Id: <10752.127552@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_01C0871D.6C6C66BE
Content-Type: text/plain;

charset="iso-8859-1"

I tried on Solaris 2.7, Oracle 804. It is working.

Select next_day(sysdate, 'Friday') from dual;

Rao

Maheswara.Rao_at_SunGardP3.com <mailto:Maheswara.Rao_at_SunGardP3.com>

-----Original Message-----
From: Alex Hillman [mailto:alex_hillman_at_physia.com] Sent: Thursday, January 25, 2001 11:16 AM To: Multiple recipients of list ORACLE-L Subject: RE: ?

I have 8.1.6.2 on NT and this query worked. Alex Hillman
-----Original Message-----
From: Kevin Kostyszyn [ mailto:kevin_at_dulcian.com <mailto:kevin_at_dulcian.com> ]
Sent: Thursday, January 25, 2001 11:02 AM To: Multiple recipients of list ORACLE-L Subject: ?

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
Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
kevin_at_dulcian.com

------_=_NextPart_001_01C0871D.6C6C66BE
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">

<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 9">
<meta name=3DOriginator content=3D"Microsoft Word 9">
<link rel=3DFile-List href=3D"cid:filelist.xml_at_01C086F4.5BBA6BA0">
<title>RE: ?</title>
<!--[if gte mso 9]><xml>
<w:WordDocument>

  <w:Zoom>0</w:Zoom>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:EnvelopeVis/>
  <w:Compatibility>
   <w:ForgetLastTabAlignment/>

<w:DoNotUseHTMLParagraphAutoSpacing/> </w:Compatibility>
</w:WordDocument>
</xml><![endif]-->
<style>
<!--

/* Font Definitions */
@font-face

	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;
	mso-font-charset:0;
	mso-generic-font-family:swiss;
	mso-font-pitch:variable;
	mso-font-signature:553679495 -2147483648 8 0 66047 0;}

/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal

	{mso-style-parent:"";
	margin:0in;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:12.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;
	text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
	{color:blue;
	text-decoration:underline;
	text-underline:single;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
	{margin:0in;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:12.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";}
p
	{margin-right:0in;
	mso-margin-top-alt:auto;
	mso-margin-bottom-alt:auto;
	margin-left:0in;
	mso-pagination:widow-orphan;
	font-size:12.0pt;
	font-family:"Times New Roman";
	mso-fareast-font-family:"Times New Roman";}
span.EmailStyle18
	{mso-style-type:personal-reply;
	mso-ansi-font-size:10.0pt;
	mso-ascii-font-family:Arial;
	mso-hansi-font-family:Arial;
	mso-bidi-font-family:Arial;
	color:navy;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;
	mso-header-margin:.5in;
	mso-footer-margin:.5in;
	mso-paper-source:0;}
div.Section1
	{page:Section1;}

-->
</style>
</head>

<body lang=3DEN-US link=3Dblue vlink=3Dblue =
style=3D'tab-interval:.5in'>

<div class=3DSection1>

I= tried on
Solaris 2.7, Oracle 804. It is =
working.<o:p></o:p>

<font size=3D2 =

color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><=
![if =

!supportEmptyParas]> <![endif]><o:p></o:p>=

S= elect
next_day(sysdate, ‘Friday’) from = dual;<o:p></o:p>

<font size=3D2 =

color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><=
![if =

!supportEmptyParas]> <![endif]><o:p></o:p>=

<font size=3D2 =

color=3Dnavy face=3DArial><span
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><=
![if =

!supportEmptyParas]> <![endif]><o:p></o:p>=

<a = href=3D"mailto:Maheswara.Rao_at_SunGardP3.com" title=3D"Return Mail =
Address">Maheswara.Rao_at_SunGardP3.com</a><o:p></o:p><= /p>

=
<span

class=3DEmailStyle18><![if = !supportEmptyParas]> <![endif]><o:p></o:p>=

-----Original Message----- 
From: Alex Hillman
[mailto:alex_hillman_at_physia.com] 
Sent: Thursday, January =
25, 2001
11:16 AM 
To: Multiple recipients =
of list
ORACLE-L 
Subject: RE: =
?

<![if =
!supportEmptyParas]> <![endif]><o:p></o:p>

I have 8.1.6.2 on NT and this = query

worked.</span></font><font color=3Dblack><span style=3D'color:black'> =

<font

color=3Dblack><o:p></o:p>=


<span

style=3D'font-size:10.0pt;color:black'>Alex Hillman</span></font><font
color=3Dblack><span style=3D'color:black'> </span></font><font =
color=3Dblack><span
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font>=

-----Original = Message----- 
From: Kevin Kostyszyn [<a = href=3D"mailto:kevin_at_dulcian.com">mailto:kevin_at_dulcian.com</a>]</= font> 
Sent: Thursday, January 25, 2001 11:02 = AM 
To: Multiple recipients of list = ORACLE-L 
Subject: ?
<o:p></o:p>=


<![if = !supportEmptyParas]> <![endif]><o:p></o:p>=


Does anyone have any idea how I = should
solve the following problem <o:p></o:p>

  1  select = next_day(sysdate,
'friday') =
 
  2* from dual 
SQL> /
 
from dual
 
     * 
ERROR at line 2: 
ORA-00600: internal error code, arguments: [17182], = [845146248],
[], [], [], 
[], [], []
<o:p></o:p>=


8.1.6  = NT<font

color=3Dblack><span style=3D'color:black'> </span></font><font =
color=3Dblack><span
style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font>=

<span

style=3D'font-size:10.0pt;color:black'>Sincerely,</span></font><font =
color=3Dblack><span
style=3D'color:black'> <br>

Kevin Kostyszyn 
DBA 
Dulcian, Inc 
www.dulcian.com 
kevin_at_dulcian.com <o:p></o:p> Received on Thu Jan 25 2001 - 16:23:20 CST