Re: selfjoin and object type causes SIGSEGV

From: Oleg Paraschenko <usenet_at_sein.sportwetten.spb.ru>
Date: 26 Jun 2003 00:18:32 -0700
Message-ID: <70f723dc.0306252318.baf149c@posting.google.com>

Hello all,

In OTN forum (http://www.oracle.com/forums/thread.jsp?forum=68&thread=186463) Barbara Boehmer suggested me to rewrite join to use non-ANSI syntax:

variable c refcursor
begin
open :c for
select bi1.bar_foo.getFoo() foo1,
bi2.bar_foo.getFoo() foo2
from bar_pairs bp, bar_items bi1, bar_items bi2 where bp.bar_id_1 = bi1.bar_id
and bp.bar_id_2 = bi2.bar_id;
end;
/

Oracle now works.

But if someone wish to make Oracle better, please submit problem to Oracle support team. I do not have metalink access.

Regards, Oleg Received on Thu Jun 26 2003 - 02:18:32 CDT