Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ??? How to insert LONG values
In OCI with version 7.3 you have piecewise insert and update.
In versions 7.1 and up, you have piecewise fetch.
this only works with OCI... You can mix oci with Pro*c easily using sqllda....
On Tue, 10 Dec 1996 15:50:09 +0300, "Alex M. Ruzin" <00alex_at_demos.su> wrote:
>Hi All!
>
>I'm using C OCI.
>Is there a way to insert very LONG values by portions?
>I've found fetchlng() fucntion letting retrieve portions of
>a LONG columns, but I havn't found a way to put portion of data.
>As believed Oracle LONG can contain up to 2GB bytes, suppose
>I want to use it. So I have storage for 10 such records (~20GB),
>But I have a little RAM (128MB).
>Is it possible for me to insert such a long record?
>
>Thank you a lot.
>
>Alex
Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com