Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: using the long datatype in Oracle 7.2
A copy of this was sent to "Daniel Clamage" <dclamageNOSPAM_at_telerama.com>
(if that email address didn't require changing)
On Wed, 2 Dec 1998 23:23:40 -0000, you wrote:
>But you're limited to a max string size of 32K. To insert longer LONGs, you
>need to use Pro*C or similar product.
>
>I sent an email to Keith Majkut, Sr. SW Engineer at Oracle, asking him to
>pass on to the PL/SQL development team a request for a way to insert 2GB of
>LONG data, as there is a way to fetch LONGs in PL/SQL, using
>DBMS_SQL.column_value_long. I didn't get a reply, however. Maybe when 8.1
>rolls along...
In 8.0 (no need to wait for 8.1), CLOBS effectively replace LONGS and BLOBS replace long raws.
both clobs and blobs provide for piecewise access for reading and writing in all clients, without exception.
In 8.1, there is a function, to_lob, to easily convert a long/long raw to a clob/blob.
longs and long raws should be avoided in 8.0 and up as their functionality is limited compared to clobs and blobs.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
--
http://govt.us.oracle.com/ -- downloadable utilities
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 Wed Dec 02 1998 - 22:48:00 CST
![]() |
![]() |