Re: BLOBs in 7.3; Good or bad idea?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 1998/01/22
Message-ID: <34cfac84.2530468@192.86.155.100>#1/1

On Tue, 20 Jan 1998 22:07:10 -0500, "ANDREW E KOSLOV" <akoslov_at_clark.net> wrote:

>Dana, I'm not sure I fully understand the idea, but here's my 5 cents worth:
>prior to 8.0, the largest size of a BLOB is 32K; if your reports are MB's in

thats not right, the largest blob in Oracle7.x is 2gig. In Oracle8.x its 4gig.

You might be refering to the limit that pl/sql has. if you don't use C and want to use pl/sql, the largest blob pl/sql can handle is 32k. the same is true in O8 however piecewise operations for reading/writing BLOBS is added so even though you can only access 32k at a time, you can access the whole blob like a file by seeking to any offset and reading 32k. In C in 7.x you have the piecewise access to longs/long raws.

[snip]
>
>Regards,
>-Andrew
>
>Dana Stockler wrote in message <01bd2588$5a9e36a0$8e85a488_at_ws10>...
>>Hi Oracle Gurus,
>>
>>We are running WinNT 4.0 / Oracle 7.3.
>>
>>One of our developers ...
>
>
>>TIA,
>>Dana Stockler
>>(Parallel E-mail replies appreciated)
>>
>
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD  

http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Jan 22 1998 - 00:00:00 CST