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 -> problems in using setAsciiStream() while inserting objects of large sizes

problems in using setAsciiStream() while inserting objects of large sizes

From: Amit Soni <amit.soni_at_oracle.com>
Date: Wed, 29 Oct 2003 13:05:18 +0530
Message-ID: <OcKnb.49$sF1.332@news.oracle.com> 





Hi people,


I am using setAsciiStream() to insert data af size about 22MB. But there 
are two problems in that:


1) A parameter of setAsciiStream() is of type int and it takes the 
length  of the stream available. So 22MB size cannot be specified using int
2) If I use preparedStatement's setAsciiStream() to put data in chunks 
(in a while loop with the chunk size of 2K), only the data of the last 
setAsciiStream() is pushed in the db.



Thanks in advance,


Amit.
Received on Wed Oct 29 2003 - 01:35:18 CST












Original text of this message













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