ora-600 with table...cast... on 10.2.0.3 / al32utf8 / linux

From: codadilupo <codadilupo_at_operamail.com>
Date: Fri, 01 Feb 2008 16:32:49 +0100
Message-ID: <47a33ba1$0$21204$5fc30a8@news.tiscali.it>


If you have a 10.2.0.3 AL32UTF8 DB on Linux, are you able to reproduce this?

Script p.sql is:



declare
  x1 Varchar2TableType ;
  x2 Varchar2TableType ;
begin
  x1 := Varchar2TableType('aaa','bbb','ccc') ;   select
    column_value val
  bulk collect into
    x2
  from
    table(cast(x1 as Varchar2TableType))   ;
end ;
/

SQL> create or replace type Varchar2TableType as table of varchar2(32767 byte);
  2 /

Type created.

SQL> @s

PL/SQL procedure successfully completed.

SQL> create or replace type Varchar2TableType as table of varchar2(32767 char);
  2 /

Type created.

SQL> @s
declare
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [15201], [], [], [], [], [], [], []
ORA-06512: at line 6 Received on Fri Feb 01 2008 - 09:32:49 CST

Original text of this message