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

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@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org