Re: ora-600 with table...cast... on 10.2.0.3 / al32utf8 / linux
Date: Fri, 1 Feb 2008 07:51:27 -0800 (PST)
Message-ID: <d03ca361-689a-456c-b016-1662cfe68292@q39g2000hsf.googlegroups.com>
On 1 Feb, 15:32, codadilupo <codadil..._at_operamail.com> wrote:
> 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
Not me:
[oracle_at_xxxx ~]$ uname -a
Linux 2.6.9-22.ELsmp #1 SMP Mon Sep 19 18:32:14 EDT 2005 i686 athlon
i386 GNU/Linux
SQL> select * from v$version;
BANNER
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 -
Production
CORE 10.2.0.1.0
Production
TNS for Linux: Version 10.2.0.1.0 -
Production
NLSRTL Version 10.2.0.1.0 -
Production
1 declare
2 x1 Varchar2TableType ;
3 x2 Varchar2TableType ;
4 begin
5 x1 := Varchar2TableType('aaa','bbb','ccc') ;
6 select
7 column_value val
8 bulk collect into
9 x2
10 from
11 table(cast(x1 as Varchar2TableType))
12 ;
13* end ;
SQL> save s.sql
Created file s.sql
1* create or replace type Varchar2TableType as table of
varchar2(32767 byte);
SQL> /
Type created.
SQL> @s
PL/SQL procedure successfully completed.
1* create or replace type Varchar2TableType as table of
varchar2(32767 char);
SQL> /
Type created.
SQL> @s
PL/SQL procedure successfully completed.
SQL> spool off Received on Fri Feb 01 2008 - 09:51:27 CST