----------------------------
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SQL> select to_char(sysdate,'dd.mm.yyyy') from dual;
TO_CHAR(SY
----------
15.10.2002
-------------------------------
It's doing fine... on Win2k.
Nirmal.
-----Original Message-----
Sent: Tuesday, October 15, 2002 12:03 PM
To: Multiple recipients of list ORACLE-L
hi!
8.1.7. on WIN:
due to a bug - it seems - the following query returns an error:
SQL> SELECT TO_CHAR(SYSDATE, 'dd.mm.yyyy') from dual;
SELECT TO_CHAR(SYSDATE, 'dd.mm.yyyy') from dual
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [17182], [538241312], [], [],
[],
[], [], []
while it works fine on 8.0.5. and 8.1.6.!
does anyone know a way to change the query, so it will work on all
version and there is no need for a patch?
tia & regards
daniel
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Daniel Wisser
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar Muthu Kumaran
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
