Insert of LONG RAW values

From: Roger Bjarevall <ebcrbj_at_ebc.ericsson.se>
Date: Fri, 12 Nov 1993 23:05:02 GMT
Message-ID: <1993Nov12.230502.17119_at_ericsson.se>


We are planning to store 'files' in Oracle 7 using a LONG RAW field. According to the documentation it is possible to fetch blocks using the OCI C-call oflng() of information from a LONG RAW field but there is no opposite to store blocks in the field.

The only way as I can see is to allocate memory of the filesize and insert it in one OCI C-call (this wont work if there isn't enough of primary memory).

Have I missed something or is it impossible to feed a LONG RAW field with 'much' data?

I have talked with Oracle and they suggested me to split the files into 32Kb blocks and put them into the table with an additional sequence number telling the location of each block in the file.

Any solutions?

+------------------------------------------------------------------+

+       _/_/_/    _/_/_/   _/_/_/_/  Roger Bjärevall               +
+      _/    _/  _/    _/       _/   BO/EBC/KX/RGFC                +
+     _/    _/  _/    _/       _/    Ericsson Business Networks AB +
+    _/_/_/_/  _/_/_/_/       _/     135 83 Tyresö                 +
+   _/  _/    _/    _/  _/   _/      +46 8 6824851                 +
+  _/    _/  _/    _/  _/   _/                                     +
+ _/     _/ _/_/_/      _/_/         email: ebcrbj_at_ebc.ericsson.se +

+------------------------------------------------------------------+
Received on Sat Nov 13 1993 - 00:05:02 CET

Original text of this message