Message-Id: <10752.127552@fatcity.com> From: "Rao, Maheswara" Date: Thu, 25 Jan 2001 17:23:20 -0500 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_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@SunGardP3.com -----Original Message----- From: Alex Hillman [mailto:alex_hillman@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@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@dulcian.com ------_=_NextPart_001_01C0871D.6C6C66BE Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: ?

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

<= ![if = !supportEmptyParas]> 

=

S= elect next_day(sysdate, ‘Friday’) from = dual;

<= ![if = !supportEmptyParas]> 

=

R= ao

<= ![if = !supportEmptyParas]> 

=

Maheswara.Rao@SunGardP3.com<= /p>

=  

=

-----Original Message-----
From: Alex Hillman [mailto:alex_hillman@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@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@dulcian.com