Re: Can I add a float array into the Oracle database?

You can have a varray of type number. There are limitations. You cannot search on it, you cannot update just one element in the array and it is limited in size to the size you specify when you define it. I think it is limited to 4,000 elements as a total length. I don't know if the ADO driver knows how to handle this type of stuff.

Jim

"Mark Liao" <markl_at_symtrontech.com> wrote in message news:9sfv03$1ps$1_at_news.is.net.tw...
> Dear All,
>
> I use VC and ADO to create a database program. The database system I used
is
> the Oracle 9i. The new case I got is to add a float array into the Oracle
> system. Since I use ADO, I treat the float array as a byte array. My
program
> uses a VARIANT object to handle the datatype (VT_ARRAY | VT_R4) and data
> content. And while it call ADO to add data into the Oracle, the ADO return
> an error.
>
> If I transfer the float array to byte array, then everything is fine.
> However, I don't want to do the datatype transfer because datatype
transfer
> will waste lots of time while data amount is huge. So, I want to know
"Does
> the Oracle support any datatype of field can handle a float array?".
>
>
> Mark Liao ^^*
>
>
Received on Fri Nov 09 2001 - 01:30:01 CST