Home

Bug in 9iR2 with embedding an ANYDATA collection in an ANYDATA column

Fri, 2006.05.26 - 07:50 — müzso
I've found another bug in 9iR2. Smile It occurs if you try to insert an ANYDATA collection (nested table) into a table column of ANYDATA type.

Here's an example that demonstrates the bug:
create table anydata_test(
  col anydata
);
create or replace type t_anydata_test is table of anydata
/
declare
  rCol anydata;
begin
  rCol := ANYDATA.ConvertCollection( t_anydata_test( ANYDATA.ConvertNumber(1) ) );
  insert into anydata_test(col) values (rCol);
end;
/

Oracle throws an "ORA-03113: end-of-file on communication channel" exception if you run the above code (and of course your Oracle session is aborted). The PL/SQL engine has no problem with this kind of embedding of ANYDATA type in a collection ... the problem appears only if you try to store the value in a table column.