RE: ora 600 [17182]

From: <babu.nagarajan_at_mail.iflexsolutions.com>
Date: Tue, 1 Aug 2000 14:42:41 +0530
Message-Id: <10576.113456@fatcity.com>

hi

u are right... the bug is when i have a different nls_sort from the = server
and the client and do a union ... order by ... desc then i am supposed = to
hit this bug.

during my checks, i was able to avoind getting the 600 by doing some = random
selects after i fire this union...desc query... otherwise if i exit immediately after the qry, i get the error...

babu

-----Original Message-----
From: paquette stephane [mailto:stephane_paquette_at_yahoo.com] Sent: Monday, July 31, 2000 10:17 PM
To: Multiple recipients of list ORACLE-L Subject: Re: ora 600 [17182]

If my memory is good, it's a bug on 8.1.5, it occurs when a session with a different nls language than the server do an order by ...desc.

• babu.nagarajan_at_mail.iflexsolutions.com a =E9crit=A0: > Hi
  > =20
  > We are getting this error - ora 600 [17182] duing a
  > particular forms
  > operation at one of our clients site. The server is
  > on Win NT - Terminal
  > Server edition and Oracle is 815. I know this error
  > is due to heap
  > corruption in memory. I searched metalink with not
  > much help. the
  > suggestions it gave to upgrade to 8151 and to set
  > timed_Statistics to false
  > did not work...
  > =20
  > Have any of you encountered this error before and
  > what did you do to solve
  > it...
  > =20
  > TIA
  > =20
  > Babu Nagarajan
  > i-Flex, Bangalore
  > #91-80-5597600-3381
  > =20
  >=20
  > =20
  >=20

=3D=3D=3D=3D=3D
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50

---

Do You Yahoo!?
Kick off your party with Yahoo! Invites. http://invites.yahoo.com/
--=20
Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D   INET: stephane_paquette_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may Received on Tue Aug 01 2000 - 04:12:41 CDT