Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ??? How to insert LONG values

Re: ??? How to insert LONG values

From: Thomas J. Kyte <tkyte_at_us.oracle.com>
Date: 1996/12/10
Message-ID: <32ad7c3c.1996440@dcsun4>#1/1

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                          

http://govt.us.oracle.com


statements and opinions are mine and do not necessarily reflect the opinions of Oracle Corporation Received on Tue Dec 10 1996 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US