Re: Inserting a long raw column 2

In article <92sqjo$v2o$1_at_nnrp1.deja.com>,   mtanck_at_my-deja.com wrote:
> A Lob cannot be used. We need to use the long raw datatype.
> I am using Oracle 8.05 and trying to insert a *.mdb file
> into an column of type long raw.
>
> Sent via Deja.com
> http://www.deja.com/
>

You can always use a LOB instead of a long raw. By definition, the LOB has all features of the long raw plus double the space and feature/packages for accessing the data. Are you suggesting that the system(s) that you are using are not compatible with LOB?

As to inserting a file into a long, the only way that I have known/been able to do is: using C/C++ read the file into a (large) buffer, then insert the buffer. PL/SQL will not work as the size of it's LONG is 32K.

SQLLoader will insert files into LOB by reference to the file name with some restrictions. ( see Loader manual ) When using LOBs it is possible to read blocks of data ( file ), and append them to the end of the LOB.

--
Michael Krolewski
Rosetta Inpharmatics
mkrolewski_at_rii.com
              Usual disclaimers


Sent via Deja.com
http://www.deja.com/