VARRAY Object types for Numbers, how to avoid roundoff?

From: Dan McIntyre <mcintyre_at_pclink.com>
Date: Thu, 22 Jul 1999 00:01:50 -0500
Message-ID: <7n692c$2adq@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?

Otherwise the VARRAY collection type is great for PLSQL handling of array type data which is used as a single unit anyway.

Thanks,

Dan McIntyre
Univ of Minn
mcintyre_at_cs.umn.edu Received on Thu Jul 22 1999 - 00:01:50 CDT