ora-600...

From: Bricklen <bricklen_at_shaw.ca>
Date: Sun, 06 Oct 2002 23:40:36 GMT
Message-ID: <3DA0C839.E3E1DFCF@shaw.ca>

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 Received on Sun Oct 06 2002 - 18:40:36 CDT