Re: Strange

When you get such an error, call oracle support you may need some patches, there is a problem with the database.

Tom
Ethan Post <epost1NOepSPAM_at_yahoo.com.invalid> wrote in message news:000806c4.a297918f_at_usw-ex0105-037.remarq.com...
> 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 Fri Jul 21 2000 - 00:00:00 CDT