Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> help -- ora 600

help -- ora 600

From: Stefan Jahnke <Stefan.Jahnke_at_bov.de>
Date: Thu, 13 Mar 2003 01:18:39 -0800
Message-ID: <F001.00568A1F.20030313011839@fatcity.com>


Hi everybody

Oracle 9.2.0.1.0 on Win2k SP2. Issuing the following statement via JDBC thin driver connection leads to

ORA-00600: Interner Fehlercode, Argumente: [ttcgcshnd-1], [0], [], [], [], [], [], []

Statement is:

SELECT

   alias0.ENT_ID,
   alias0.ENT_OID,
   alias0.ENT_CREATE_USER,
   alias0.ENT_CREATE_DATE,
   alias0.ENT_UPDATE_USER,
   alias0.ENT_UPDATE_DATE,
   alias0.ENT_TYPE,
   alias1.PRO_ID,
   alias1.PRO_NAME,
   alias1.PRO_VALUE,
   alias1.PRO_ENT_ID,
   alias1.PRO_CREATE_USER,
   alias1.PRO_CREATE_DATE,
   alias1.PRO_UPDATE_USER,
   alias1.PRO_UPDATE_DATE
 FROM  AFENTITY alias0
          LEFT OUTER JOIN AFPROPERTY alias1
              ON alias0.ENT_ID = alias1.PRO_ENT_ID
 WHERE (alias1.PRO_NAME = 'NAME'
       AND alias1.PRO_VALUE = 'ADMIN/test')
 ORDER BY alias0.ENT_ID

The statement works fine when it's executed in sql*plus. Other statements before (through jdbc thin connection).

Here is the header of the trace file:

Dump file f:\oracle\admin\vista9itest\udump\vista9itest_ora_2308.trc Thu Mar 13 09:28:34 2003
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 3, CPU type 586 Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 3, CPU type 586 Instance name: vista9itest

Redo thread mounted by this instance: 1

Oracle process number: 17

Windows thread id: 2308, image: ORACLE.EXE

location             type     point                (? means dubious value)

-------------------- -------- --------------------
----------------------------

_ksedmp+147 CALLrel _ksedst+0
_ksfdmp.108+e CALLrel _ksedmp+0 3
_kgerinv+83 CALLreg 00000000 578B730 3
_kgeasnmierr+13 CALLrel _kgerinv+0 578B730 9CF55B8 6058AD28
1 9C3D3B8
__VInfreq__ttcc2u+a CALLrel _kgeasnmierr+0 578B730 9CF55B8 6058AD28
1 0 1c 0
__PGOSF32__opifcr+3 CALLreg 00000000 578B730 5791880 0 0 1 1
fa 9C3D43C 9D0C4B8
_qerflRop+33 CALLreg 00000000 9C3DB90 A
_qersoFetch+66b CALLreg 00000000 9C3DA4C A
_qerflFetch+e8 CALL??? 00000000 688BC688 1077000 9C3DA4C
A
_qerjoFetch+ed CALL??? 00000000
..1.3_1.filter.30+2 CALL??? 00000000 688BC600 7697CC 9C3DB90 A 29 ..1.2_1.filter.25+3 CALLrel _opifch2+0 89 5 9C3DE64 1a

I'm wondering about "SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT'". Is this the statement causing the problem ? Works fine within in sql*plus. Also, comparing the output of SELECT * FROM NLS_INSTANCE_PARAMETERS; on the instance that doesn't work with one that does, it shows the same results.

What's the deal here ? Any ideas ?

TIA,
Stefan

Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
mailto: stefan.jahnke_at_nospam.bov.de
Please remove nospam to contact me via email.

visit our website: http://www.bov.de
subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp

Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:andrea.palluck_at_bov.de.

Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen.

As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above.  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stefan Jahnke
  INET: Stefan.Jahnke_at_bov.de

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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
also send the HELP command for other information (like subscribing).
Received on Thu Mar 13 2003 - 03:18:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US