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

You'll love this:

First - the thing behaves on my 8.0.4 exactly as it behaves on your 8.0.5 - output is rounded. Had to eliminate the ORDER function, and write a create table, of course, to emulate your example.

Then I ran it on 8.1.5; the result of the select was .....

        NO ROWS RETURNED !!!!! even when I dropped the precision of the values back to number(6). I even did a DUMP(tdi_params) to demonstrate that the data stored wasn't causing a problem because of conversion rounding.

On a simple select without a WHERE the values displayed showed the precision at which they had been entered.

have we got bugs here, or what ?
Come back T Kyte - all is forgiven.

--

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

Dan McIntyre wrote in message <7n7h89$enb_at_enews3.newsguy.com>...
>Thanks for looking at my problem, I am using Oracle 8.0.5.0.0. Here are
the
>declarations I used and a simple INSERT followed by a SELECT showing the
>rounded values which are supposed to be in NUMBER(6,2). Is there another
>way to retrieve collection type data from the database?
Received on Thu Jul 22 1999 - 13:48:15 CDT