Re: How to insert a file in a CLOB field.

Balabiot wrote:
> Hi,
>
> I have to migrate a mysql table in a oracle table with the same
> structure (with the opportune conversions of the datatypes).
>
> Unfortunatly, a field in the source database is a longtext, that in
> oracle is a CLOB. I try to copy all field the data with java, .net and
> vb6 without success.
>
> So I have to take the decision of migrate only the field with simple
> datatype (varchar2, number and date), and with a vb6 program, download
> on my pc mysql longtext, and this operation is ok.
>
> with an another .net program I'm successful to import file with size
> not more than 3 or 4K, but I have to import file with size of 2M, but
> in this case (and when the size is 6K) I have the follow error :
> Can bind a LONG value only for insert into a LONG column
>
> I have read that in a CLOB I can insert 4GB.
>
> Someone can help me?
>
> Thank you so much.
> Ciao
> Balabiot
>
>
>
> I have to insert a file (.jpg, .xls and .gif) in a CLOB field.
>
> With .net I can

You don't explain why you are having problems moving the CLOB data. If you did someone might be able to help you.

To load either look at the following built-in packages. UTL_FILE
DBMS_LOB
INTERMEDIA All with demos at www.psoug.org in Morgan's Library.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org