Re: How to store large objects in ORACLE 7.0.13?

From: Simon Stearn BT group <sjs_at_metagen.co.uk>
Date: Mon, 17 Jan 94 14:00:50 GMT
Message-ID: <1994Jan17.140050.346_at_metagen.co.uk>


In article <2h3gmm$6mv_at_fuhainf.fernuni-hagen.de>, kienbaum_at_trabant.fernuni-hagen.de (Uwe Kienbaum) writes:
|>
|> Hello world,
|>
|> i am using ORACLE 7.0.13 to establish a multimedia-database containing sound,
|> photographs, scanned documents etc. I already tried to use the PRO*C-structure
|> VARCHAR[n] to store a gif-picture from a file into a table via C-vaiable of typeVARCHAR. But this type is limited to 65333 Bytes length an i need more.
|> How do i get a 1MB picture into a single row of type LONG RAW??? I know there is someone out there who has solved this problem yet and i would be very pleased to receive an answer.
|>
|> Thanks, in advance.
|> --
|> Uwe Kienbaum
|> Student at the university of Dortmund
|> EMAIL:kienbaum_at_galaxy.fernuni-hagen.de

To manipulate LONG RAW types effectively, you need to resort to the OCI - this allows chunk by chunk manipulation of data. (I don't the manual handy - take a peek)

If you just want to deal with the 1MB blob all at once from within PRO*C, you need to perform a datatype equivilence with VARRAW. See the manual for an example of this.

Hope this helps,

Simon.

(just my opinion, thats all) Received on Mon Jan 17 1994 - 15:00:50 CET

Original text of this message