Hi, I'm new to databases and have a project that I'm having problems with.

I'm involved with engineering / scientific applications and would like to store arrays of data.  These arrays can vary in length, but we can assume that there are between 10000 and 15000 doubles.

I'm aware that I can use char(x) datatype to store my data, but I would really like to learn how to use the BLOB datatype.

I'm currently running vb6 and accessing a oracle 9i database through ADO 2.7.

I've created a table with the following string:

CREATE TABLE testtable (data BLOB)

can someone give me an example of how I could add an array of doubles to this table?  Is this table format even legit? I know that I should have a primary key, but right now I'm not even able to store a single record, let alone multiple records.

thanks all.