Strange

From: Ethan Post <epost1NOepSPAM_at_yahoo.com.invalid>
Date: 2000/07/20
Message-ID: <000806c4.a297918f@usw-ex0105-037.remarq.com>#1/1

This just occured and makes no sense to me, it's working now but here is the SQL I was running, you will notice that an error was occuring and then it just stopped, I reran the original statements with no problem. I have no idea what was causing it but not very reasurring.

---

SQL> select TO_DATE(TO_CHAR(SYSDATE, 'HH24:MI'), 'HH24:MI') dt from dual;
select TO_DATE(TO_CHAR(SYSDATE, 'HH24:MI'), 'HH24:MI') dt from dual

               *
ERROR at line 1:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

SQL> select to_char(sysdate, 'HH24:MI') from dual; select to_char(sysdate, 'HH24:MI') from dual

       *
ERROR at line 1:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []

SQL> select to_char(sysdate, 'MON-DD-RR') from dual;

TO_CHAR(S

---

JUL-20-00 SQL> select to_char(sysdate, 'HH24:MI') from dual;

TO_CH

---

15:17

SQL> select TO_DATE(TO_CHAR(SYSDATE, 'HH24:MI'), 'HH24:MI') dt from dual;

DT

---

01-JUL-00 SQL>

---

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Thu Jul 20 2000 - 00:00:00 CDT