| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> help -- ora 600
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
 |
 |