Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using long raw
"Don" <don_at_nrgdb.com> wrote in message
news:4L5L5.1216$O7Kd.19333294_at_news.xtra.co.nz...
> Hi
>
> I'm using the Long Raw datatype because our needs are for fairly small
> binary storage (typically only a few K) and it is much more efficicient in
> the table than out.
I take it that 'only a few K' is more than 4K? Because BLOBS up to 4K in size are stored in-line like Long Raws.
Just checking
HJR
But - while i can store and return to my client
> applications the stored binary I wish to avoid storing the same binary
> twice. So i figure I will look for any binaries that have the same length
> and compare them with one to be saved before I actually save it otherwise
I
> will simply point to the existing binary record. But how do I find the
> length of a long raw and then how do I compare them inside PL/SQL.
>
> I have tried opening a cursor from DBMS_SQL then using the
column_value_long
> function to retrieve the data in chunks but this seems to fail due to it
> being long raw rather than long.
>
> Don't know what I am doing wrong but would really appreciate some help.
> Thanks in advance.
>
> Don
>
>
Received on Mon Oct 30 2000 - 09:45:49 CST