Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ora-600...
Bricklen wrote:
>
> Anyone else seen this? Was just trying some string results from dual and
> got the following (8.1.7):
>
> SQL>select '''''' from dual;
> select '''''' from dual
> *
> ERROR at line 1:
> ORA-00600: internal error code, arguments: [17182], [159051124], [], [],
> [], [], [], []
>
> SQL>select '''a''' from dual;
> ''A''
> --------------------------------
> 'a'
>
> 1 row selected.
>
> SQL>select '''ab''' from dual;
> ''AB''
> --------------------------------
> 'ab'
>
> 1 row selected.
>
> SQL>select '''abc''' from dual;
> ''ABC''
> --------------------------------
> 'abc'
>
> 1 row selected.
>
> SQL>select '''abcd''' from dual;
> select '''abcd''' from dual
> *
> ERROR at line 1:
> ORA-00600: internal error code, arguments: [17182], [159051124], [], [],
> [], [], [], []
>
> SQL>select '''abcde''' from dual;
> ''ABCDE''
> --------------------------------
> 'abcde'
>
> 1 row selected.
>
> SQL>select '''abcdef''' from dual;
> ''ABCDEF''
> --------------------------------
> 'abcdef'
>
> 1 row selected.
>
> Not asking for advice or the obligatory admonition to contact support,
> just thought it curious that 0, 3, or 4 would cause ORA-600's.
> ^^^^^^^^^^^
> Cheers,
>
> Bricklen
That should read "0 or 4 characters..."
Received on Sun Oct 06 2002 - 18:43:07 CDT
![]() |
![]() |