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>
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 ;
/
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