Re: selfjoin and object type causes SIGSEGV

On 26 Jun 2003 00:18:32 -0700, usenet_at_sein.sportwetten.spb.ru (Oleg Paraschenko) wrote:

>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

The above syntax definitely IS ANSI-syntax. Why would we submit TARs on your behalf. We would need to stay in touch with you to address feedback from Oracle. Don't you think this falls outside the scope of a volunteer group, and the user helping you out is just giving away money?

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jun 26 2003 - 15:38:45 CDT