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

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 22 Jul 1999 16:09:26 +0100
Message-ID: <932656473.4404.0.nnrp-13.9e984b29@news.demon.co.uk>

Can you give us a very simple example ? I have been trying to reproduce this on 8.1.5 and keep getting full precision output.

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

Dan McIntyre wrote in message <7n692c$2adq_at_enews4.newsguy.com>...
>Hi,
>
> I am using the VARRAY collection data type both as a standalone column
and
>as an Object containing the array and I find that types defined as VARRAY's
>of , say, NUMBER(6,2) show only rounded off integers when retrieved from
the
>database. Comparison operators for the Object type indicate that the full
>precision is being stored correctly. Is there a way to control the display
>user defined types and Objects when retrieved from the database?
>
Received on Thu Jul 22 1999 - 10:09:26 CDT