selfjoin and object type causes SIGSEGV

Hello all,

  I'm trying to use Oracle Object-Oriented (OO) features, and stopped on very first steps. Basic functionality not works for me, and it looks like fault of Oracle.

  I created simple object: wrapper of integer value. Member function of this object returns this value. I constructed query to return pairs of unwrapped integers. But Oracle dies with SIGSEGV instead of compiling query.

  Sample code is below. Bug is reproduced on 9.2.0.3 on: Linux oracle1 2.4.18-24.7.xsmp #1 SMP Fri Jan 31 06:10:55 EST 2003 i686 unknown
SunOS fox 5.8 Generic_108528-13 sun4u sparc SUNW,UltraAX-i2

  My questions:

• Can you reproduce this bug?
• Are some patch exists to fix it?
• Have you suggestions to workaround? Dynamic SQL works, but I wish to avoid it.
• Are OO in Oracle works at all?

  Regards, Oleg Paraschenko

  Sample code:

--

• Simple object: wrapper of integer value
  --
  create or replace type t_foo as object ( foo integer, member function getFoo return integer ); /

create or replace type body t_foo as
member function getFoo return integer
is begin
  return self.foo;
end;
end;
/

--

• Prepare tables
  --
  create table bar_pairs ( bar_id_1 integer, bar_id_2 integer );

create table bar_items (
  bar_id integer,
  bar_foo t_foo
);

--

• Produce error
  --
  variable c refcursor begin open :c for select bi1.bar_foo.getFoo() foo1, bi2.bar_foo.getFoo() foo2 from bar_pairs bp inner join bar_items bi1 on bp.bar_id_1 = bi1.bar_id inner join bar_items bi2 on bp.bar_id_2 = bi2.bar_id; end; /

Here I get:
ORA-03113: end-of-file on communication channel for client and something like
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x78, PC: [0x874a3e9, kokscfac()+479] in trace file.

--

• Cleanup
  --
  drop table bar_items; drop table bar_pairs; drop type t_foo;