Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ora-600...

Re: ora-600...

From: Bricklen <bricklen_at_shaw.ca>
Date: Sun, 06 Oct 2002 23:43:07 GMT
Message-ID: <3DA0C8D0.47CF43A8@shaw.ca>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US