Re: VARRAY Object types for Numbers, how to avoid roundoff?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 23 Jul 1999 10:12:22 +0100
Message-ID: <932721432.290.0.nnrp-13.9e984b29@news.demon.co.uk>

No, it shouldn't do.
Object types which do not specify and order function cannot be sorted, but they can be compared for equality. Two objects are equal if all their components match and are equal, so the code should work (and in fact does in 8.0.4).

Possibly the reason why Thomas Kyte couldn't find a problem with no rows returned is that his order function was a cheat - it always returns zero, i.e. ANY two tdi_param are the same.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Dan & Sue McIntyre wrote in message <37978F01.394E_at_pclink.com>...
>
> Does the SELECT problem on 8.1.5 arise from the missing order
>function? Do Objects containing other ADT's require a MAP or Order
>method to use in comparisons?
>
Received on Fri Jul 23 1999 - 04:12:22 CDT