Re: Strange

Was involved in a project where we ran into a bug with Oracle 7.3 on VMS.
On every thousand times (on average) of using "to_date", it would bum out
once with an ORA-00600 error...

Turned out to be a bug indeed. Oracle came up with a patch, problem solved. :)

Jef Jakobs

Ethan Post wrote:

> 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