Re: How can I store large strings?

From: <jonathan-bingham_at_sugen.com>
Date: Thu, 08 Jul 1999 21:30:13 GMT
Message-ID: <7m358l$nqt$1@nnrp1.deja.com>

With an Oracle LONG, you have to use the JDBC method, setAsciiStream(int i, InputStream is, int length) Then convert your String to a ByteArrayInputStream, which as a form of Ascii stream.

Jonathan

In article <7lih2p$pvv$1_at_news1.bu.edu>, tasos_at_csa.bu.edu (Anastasios Kotsikonas) wrote:
>
> Hi all,
>
> how do I insert a long string (say 64K) into an Oracle column via
JDBC?
> I am looking for the data type primarily... CLOB and LONG throw
a 'string
> literal too long' after 4K....
>
> Is there ANY way to do this? And how does one insert binary data, like
> pictures, from JDBC?
>
> thanks
>
> tasos
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 08 1999 - 16:30:13 CDT