Oracle 8 BLOB

From: <Jerry.Drexler_at_corp.honeywell.com>
Date: 14 Apr 1998 16:54:33 GMT
Message-ID: <6h04c9$7g2$1@chico.htc.honeywell.com>

The oracle 8 documentation says I can store a BLOB in the database up to 4 GBytes in size per field. The Oracle 8 OCI manual says 4000 bytes. I've tried loading binary data into a oracle 8 BLOB field using sql loader using the data type RAW in the control file. It burped if I specified a position of over 4000 bytes in the control file. I'm not sure if this is because I use RAW or because it really only does store 4000 bytes internally.

My binary data is made up of short ints, of 8192 points in length. The method I chose was to store this in a BLOB field using sql loader, and then retrieve it when needed with pro-c.

Thanks for your help!
Jerry Received on Tue Apr 14 1998 - 11:54:33 CDT