Re: beginner: LONG, BLOB, CLOB

From: MotoX <rat_at_tat.a-tat.com>
Date: Wed, 11 Nov 1998 08:13:58 -0000
Message-ID: <910771934.106.0.nnrp-02.c2de712e@news.demon.co.uk>

I've got to admit I know little about ODBC/Access. I have seen people migrate using the Migration Tool on the Oracle Web site - have you tried this?

MotoX.

Martin Trzaskalik wrote in message
<36483CA4.EB770DCA_at_ernie.mi.uni-koeln.de>...
>I am currently trying to migrate from a DBase data base to Oracle
>8.0.5.0.
>
>I imported the tables from DBase into an Access 97 Database and
>would like to use ODBC to get them into Oracle.
>
>Several tables have multiple memo fields so I can not use
>LONG to stored them because only one LONG column is allowed by
>Oracle.
>
>I tried to migrate them as CLOBs.
>However when I try to insert a Record which has a memo with more
>than 4000 bytes I get an Oracle Error:
>
>ORA-01461: can bind a LONG value only for insert into a LONG column
>
>When I insert rows with memos with less than 4000 bytes I do not
>get this error.
>
>Why is it that CLOB behaves just like VARCHAR2 even if it is a LOB?
>
>
>Thanks,
>
>Martin
Received on Wed Nov 11 1998 - 02:13:58 CST